public ActionResult ClearCommentInExcelDemo()
{
// 1.清除批注
string filePhysicalPath = SysContext.Config.ReportTemplateDirectory_Physical + "测试模板.xlsx";
using (ExcelWriter excelWriter = new ExcelWriter(filePhysicalPath, "哈哈"))
{
excelWriter.ClearCommentInCell(3, 8);
}
// 2.展现Excel文件
return(View("~/Views/Shared/Controls/ExcelReportView.cshtml", new ExcelDisplayViewModel
{
Title = "Excel清除批注 Demo",
FilePhysicalPath = filePhysicalPath,
SheetName = "哈哈"
}));
}
public ActionResult ClearCommentInExcelDemo()
{
// 1.清除批注
string filePhysicalPath = SysContext.Config.ReportTemplateDirectory_Physical + "测试模板.xlsx";
using (ExcelWriter excelWriter = new ExcelWriter(filePhysicalPath, "哈哈"))
{
excelWriter.ClearCommentInCell(3, 8);
}
// 2.展现Excel文件
return View("~/Views/Shared/Controls/ExcelReportView.cshtml", new ExcelDisplayViewModel
{
Title = "Excel清除批注 Demo",
FilePhysicalPath = filePhysicalPath,
SheetName = "哈哈"
});
}