POI、NPOI中用SXSSFWorkbook工作簿写入大量数据

string filePath = Server.MapPath("/test.xlsx");

FileStream fs = new FileStream(filePath, FileMode.OpenOrCreate, FileAccess.ReadWrite);

XSSFWorkbook workbook1 = new XSSFWorkbook();

SXSSFWorkbook sxssfWorkbook = new SXSSFWorkbook(workbook1, 100);

var first = sxssfWorkbook.CreateSheet("MySheet");

for (int i = 0; i < 1000000; i++)

{

var row = first.CreateRow(i);

for (int j = 0; j < 11; j++)

{

if (i == 0)

{

// 首行

row.CreateCell(j).SetCellValue("column" + j);

}

else

{

// 数据

if (j == 0)

{

row.CreateCell(j).SetCellValue(i.ToString());

}

else

{

row.CreateCell(j).SetCellValue(new Random().Next().ToString());

}

sxssfWorkbook.Write(fs);

fs.Close();

fs.Dispose();