public ActionResult CreateExcelReportTemlateDemo()
{
// 1.创建报表模版
string filePhysicalPath = SysContext.Config.ReportTemplateDirectory_Physical + "测试模板.xlsx";
string savePhysicalPath = SysContext.Config.TempDirectory_Physical + SysContext.CommonService.CreateUniqueNameForFile(filePhysicalPath);
using (ExcelWriter excelWriter = new ExcelWriter(filePhysicalPath, "生成报表模版", savePhysicalPath))
{
excelWriter.CreateExcelReportTemlate <ExcelDataViewModel>();
}
// 2.展现Excel文件
return(View("~/Views/Shared/Controls/ExcelReportView.cshtml", new ExcelDisplayViewModel
{
Title = "创建Excel报表模版 Demo",
FilePhysicalPath = savePhysicalPath,
SheetName = "生成报表模版"
}));
}
public ActionResult CreateExcelReportTemlateDemo()
{
// 1.创建报表模版
string filePhysicalPath = SysContext.Config.ReportTemplateDirectory_Physical + "测试模板.xlsx";
string savePhysicalPath = SysContext.Config.TempDirectory_Physical + SysContext.CommonService.CreateUniqueNameForFile(filePhysicalPath);
using (ExcelWriter excelWriter = new ExcelWriter(filePhysicalPath, "生成报表模版", savePhysicalPath))
{
excelWriter.CreateExcelReportTemlate<ExcelDataViewModel>();
}
// 2.展现Excel文件
return View("~/Views/Shared/Controls/ExcelReportView.cshtml", new ExcelDisplayViewModel
{
Title = "创建Excel报表模版 Demo",
FilePhysicalPath = savePhysicalPath,
SheetName = "生成报表模版"
});
}