//建立工作薄
var workbook = new HSSFWorkbook();
//建立表
var table = workbook.CreateSheet("joye.net");
//模拟数据
for (var i = 0; i < 40; i++)
{
var row = table.CreateRow(i);
for (int j = 0; j < 40; j++)
{
var cell = row.CreateCell(j);
cell.SetCellValue(j);
}
}
//打开xls文件,如没有则建立,如存在则在建立是不要打开该文件
using (var fs = File.OpenWrite(@"c:/joye.net.xls"))
{
workbook.Write(fs); //向打开的这个xls文件中写入mySheet表并保存。
Console.WriteLine("生成成功");
}
XSSFWorkbook为xlsx
HSSFWorkbook为 xlx
可根据上述代码自己改写
以下为自己改写
//var entity = await MapToEntityAsync(input);
//RefAsync<int> total = 0;
var entities= _DbQueryable.ToList();
var workbook = new XSSFWorkbook();
//建立表
var table = workbook.CreateSheet("joye.net");
int cellvalue = 0;
List<IRow> rowlist = new List<IRow>();
List<ICell> celllist = new List<ICell>();
for (var i = 0; i < entities.Count; i++)
{
var row = table.CreateRow(i);
rowlist.Add(row);
celllist.Add(rowlist[i].CreateCell(0));
celllist[cellvalue].SetCellValue(entities[i].WarehouseNo); cellvalue += 1;
celllist.Add(rowlist[i].CreateCell(1));
celllist[cellvalue].SetCellValue(entities[i].WarehouseName); cellvalue += 1;
celllist.Add(rowlist[i].CreateCell(2));
celllist[cellvalue].SetCellValue(entities[i].FactoryNo); cellvalue += 1;
/* celllist.Add(rowlist[i].CreateCell(3));
celllist[cellvalue].SetCellValue(entities[i].BuildNo); cellvalue += 1;*/
}
//打开xls文件,如没有则建立,如存在则在建立是不要打开该文件
await using(var fs = File.OpenWrite(@"f:/joye.net.xlsx"))
{
workbook.Write(fs); //向打开的这个xls文件中写入mySheet表并保存。
Console.WriteLine("生成成功");
}