C#利用NPOI在同一个Excel文件中创建多个sheet

https://www.bbsmax.com/A/E35pB6wRzv/

借用NPOI来实现，要在同一Excel文件中创建多个sheet，只需要在同一个workbook中创建多个sheet即可。要注意的是，sheet的名字一定不能重复。下面是实现的代码：

1. private void buttonTest_Click(object sender, EventArgs e)
2. {
3. HSSFWorkbook workBook = new HSSFWorkbook();
4. //ISheet sheetA = workBook.CreateSheet("sheetA");
5. //ISheet sheetB = workBook.CreateSheet("sheetB");
7. createSheet(workBook,"SheetA");
8. createSheet(workBook,"SheetB");
9. createSheet(workBook,"SheetC");
11. string path = Application.StartupPath + @"\test.xls";
12. if (File.Exists(path))
13. {
14. File.Delete(path);
15. }
16. using (FileStream file = new FileStream(path, FileMode.Create))
17. {
18. workBook.Write(file);　　//创建Excel文件。
19. file.Close();
20. }
21. MessageBox.Show("OK");
22. }
24. private ISheet createSheet(HSSFWorkbook workBook, string sheetName)
25. {
26. ISheet sheet = workBook.CreateSheet(sheetName);
27. IRow RowHead = sheet.CreateRow(0);
29. for (int iColumnIndex = 0; iColumnIndex < 10; iColumnIndex++)
30. {
31. RowHead.CreateCell(iColumnIndex).SetCellValue(Guid.NewGuid().ToString());
32. }
34. for (int iRowIndex = 0; iRowIndex < 20; iRowIndex++)
35. {
36. IRow RowBody = sheet.CreateRow(iRowIndex + 1);
37. for (int iColumnIndex = 0; iColumnIndex < 10; iColumnIndex++)
38. {
39. RowBody.CreateCell(iColumnIndex).SetCellValue(DateTime.Now.Millisecond);
40. sheet.AutoSizeColumn(iColumnIndex);
41. }
42. }
43. return sheet;
44. }