Workbook book = new Workbook(); // Specify which Sheet should be opened and the size of window by default book.ExcelWorkbook.ActiveSheetIndex = 1; book.ExcelWorkbook.WindowTopX = 100; book.ExcelWorkbook.WindowTopY = 200; book.ExcelWorkbook.WindowHeight = 7000; book.ExcelWorkbook.WindowWidth = 8000;
// Some optional properties of the Document book.Properties.Author = "CarlosAg"; book.Properties.Title = "My Document"; book.Properties.Created = DateTime.Now; //下面的东西可以放在一个循环里面，你想导多少个SHEET 就可以循环多少次， Worksheet sheet = book.Worksheets.Add(StoreName); sheet.Table.Columns.Add(new WorksheetColumn(150)); sheet.Table.Columns.Add(new WorksheetColumn(100)); WorksheetRow row = sheet.Table.Rows.Add(); WorksheetCell cell = new WorksheetCell(); ///
