public ActionResult AddCommentToExcelDemo()
{
// 1.添加批注
string filePhysicalPath = SysContext.Config.ReportTemplateDirectory_Physical + "测试模板.xlsx";
using (ExcelWriter excelWriter = new ExcelWriter(filePhysicalPath, "哈哈"))
{
excelWriter.AddCommentToCell(3, 1, "数据格式错误", "必须是GUID");
excelWriter.AddCommentToCell(3, 8, "数据格式错误", "必须是数字");
}
// 2.展现Excel文件
return View("~/Views/Shared/Controls/ExcelReportView.cshtml", new ExcelDisplayViewModel
{
Title = "Excel添加批注 Demo",
FilePhysicalPath = filePhysicalPath,
SheetName = "哈哈"
});
}
public ActionResult AddCommentToExcelDemo()
{
// 1.添加批注
string filePhysicalPath = SysContext.Config.ReportTemplateDirectory_Physical + "测试模板.xlsx";
using (ExcelWriter excelWriter = new ExcelWriter(filePhysicalPath, "哈哈"))
{
excelWriter.AddCommentToCell(3, 1, "数据格式错误", "必须是GUID");
excelWriter.AddCommentToCell(3, 8, "数据格式错误", "必须是数字");
}
// 2.展现Excel文件
return(View("~/Views/Shared/Controls/ExcelReportView.cshtml", new ExcelDisplayViewModel
{
Title = "Excel添加批注 Demo",
FilePhysicalPath = filePhysicalPath,
SheetName = "哈哈"
}));
}