使用的是NPOI包,NPOI.XSSF.UserModel.XSSFWorkbook
var workbook = new XSSFWorkbook();
var sheetName = "sheet1";
var sheet = workbook.CreateSheet(sheetName); //创建Excel表并取名为sheet1
var firstRow = sheet.CreateRow(0); //创建第一行为标题行
把数据放入单元格:
var row = sheet.CreateRow(i); //i指行号
var cell = row.CreateCell(j); //j指列号
// (i,j)确定了一个单元格
cell.SetCellValue(value); //value是要放入单元格的值
sheet.AutoSizeColumn(m); 自适应宽高
文件流读写操作:
var path = Path.Combine(_webHostEnvironment.ContentRootPath, "FileName");
if (!Directory.Exists(path)) //没有此路径就新建
{
Directory.CreateDirectory(path);
}
var fileName = Path.Combine(path, $"{DateTime.Now.ToString("yyyy_MM_dd_HH_mm_ss")}.xlsx");
FileStream creatStream = new FileStream(fileName, FileMode.Create, FileAccess.Write); //写
workbook.Write(creatStream);
creatStream.Close();
FileStre