在保存为 HTML 时阻止导出隐藏的工作表内容

Contents
[ ]

Aspose.Cells提供HtmlSaveOptions.ExportHiddenWorksheet 属性。默认情况下,它设置为true并且将隐藏的工作表导出为HTML。如果将其设置为false,Aspose.Cells将不会导出隐藏的工作表内容。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Create workbook object
Workbook workbook = new Workbook(dataDir + "WorkbookWithHiddenContent.xlsx");
// Do not export hidden worksheet contents
HtmlSaveOptions options = new HtmlSaveOptions();
options.ExportHiddenWorksheet = false;
// Save the workbook
workbook.Save(dataDir + "HtmlWithoutHiddenContent_out.html", options);