支持netstandard2.0, net45以上
NPOIHelper
Export Excel NPOIHelper
use
https://github.com/shaiyu/NPOIHelper
1.使用List-Model導(dǎo)出報表
public IActionResult ExportExcelList()
{
var data = GetList();
var helper = NPOIHelperBuild.GetHelper();
helper.Add("用戶列表", data);
return File(helper.ToArray(), helper.ContentType, helper.FullName);
}
2 使用DateTable導(dǎo)出報表
helper.Add("使用Fun的Dt", dt, new Column[] {
new Column("Name", "姓名", ColumnType.Default, (t, index)=> {
var dr = (DataRow)t;
return dr["Name"]+"---------"+ dr["Pwd"];
}),
new Column("Age","年齡", ColumnType.NumDecimal2),
new Column("Age","測試公式",ColumnType.Default,(t, index)=> {
return "B" + index +"*B" + index;
}) { IsFormula=true },
});
