Skip to main content

Posts

Showing posts with the label SHEET

C# Browser匯出Excel 及 建立第2個sheet

建立 SHEET 方法 範例 : ISheet sheet1 = book.CreateSheet("SHEET_NAME1");  // 開第一個 SHEET   shee1...... ISheet sheet2 = book.CreateSheet("SHEET_NAME2");  // 開第二個 SHEET   sheet2...... ---程式碼案例------------------------------------------------------------------------------------------------------- using NPOI.HSSF.UserModel; using NPOI.SS.UserModel; HSSFWorkbook book = new HSSFWorkbook (); ISheet sheet = book.CreateSheet( " sheet1 " );   //sheet 1 IRow row; IFont boldfont = book.CreateFont(); boldfont.Boldweight = ( short ) FontBoldWeight .BOLD; //設定 字型 ICellStyle cellstyle = book.CreateCellStyle(); cellstyle.SetFont(boldfont); int row_index, col_index;   //sheet1的row&col參數宣告 dt = db.ExecuteFillToDataTable(txtSQL);                          ///// sheet1內容 sheet.CreateRow(0).CreateCell(0).Set...