https://www.bbsmax.com/A/E35pB6wRzv/
借用NPOI来实现,要在同一Excel文件中创建多个sheet,只需要在同一个workbook中创建多个sheet即可。要注意的是,sheet的名字一定不能重复。下面是实现的代码:
- private void buttonTest_Click(object sender, EventArgs e)
- {
- HSSFWorkbook workBook = new HSSFWorkbook();
- //ISheet sheetA = workBook.CreateSheet("sheetA");
- //ISheet sheetB = workBook.CreateSheet("sheetB");
- createSheet(workBook,"SheetA");
- createSheet(workBook,"SheetB");
- createSheet(workBook,"SheetC");
- string path = Application.StartupPath + @"\test.xls";
- if (File.Exists(path))
- {
- File.Delete(path);
- }
- using (FileStream file = new FileStream(path, FileMode.Create))
- {
- workBook.Write(file); //创建Excel文