using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System.IO;
public void ExportToExcel()
{
IWorkbook excelDoc = new XSSFWorkbook();
ISheet excelSheet = excelDoc.CreateSheet("Sheet1");
IRow excelRow = excelSheet.CreateRow(1);//行
ICell cell1 = excelRow.CreateCell(0); //列
cell1.SetCellValue("这是第一行第一列的值");
ICell cell2 = excelRow.CreateCell(1);
cell2.SetCellValue("这是第一行第二列的值");//列参数
using (FileStream file = new FileStream("C:\\Temp\\ExportTest.xlsx", FileMode.Create, FileAccess.Write))
{
excelDoc.Write(file);
}
}
编辑写excel数据
最新推荐文章于 2024-10-07 09:48:28 发布