C# .NET 使用 NPOI 生成 .xlsx 格式 Excel

 1 iworkbook workbook = new xssfworkbook();
 2 isheet sheet = workbook.createsheet("-");
 3 irow row = sheet.createrow(0);//标题
 4 
 5 irow titlerow = row.createcell(0);
 6 row.setcellvalue("标题列1");
 7 
 8 irow datarow = sheet.createrow(1);
 9 datarow.createcell(0).setcellvalue(“第一行第一列数值”);
10 
11 string filename = "demo.xlsx";
12 
13 filestream file = new filestream("c:\\desktop\\" + filename, filemode.create);//把这个hssfworkbook实例写入文件
14 workbook.write(file);
15 file.close();
16 
17 /*如果此处要下载*/
18 //memorystream ms = new memorystream();
19 //workbook.write(ms);