Prevent Exporting Hidden Worksheet Contents on Saving to HTML

You can save Excel workbooks to HTML. However, if the workbook contains hidden worksheets, Aspose.Cells by default exports the hidden worksheet contents to the HTML output (_files) directory which contains files such as worksheets, images, tabstrip.htm, stylesheet.css, etc. Sometimes, exporting the content of the hidden worksheets this way isn’t appropriate. For example, if the hidden worksheet contains images that should not be exported to the _files directory.

Aspose.Cells provides the HtmlSaveOptions.export_hidden_worksheet property. By default, it is set to true and hidden worksheets are exported to HTML. If you set it false, Aspose.Cells will not export hidden worksheet contents.

from aspose.cells import HtmlSaveOptions, Workbook

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create workbook object
workbook = Workbook(dataDir + "WorkbookWithHiddenContent.xlsx")
#  Do not export hidden worksheet contents
options = HtmlSaveOptions()
options.export_hidden_worksheet = False
#  Save the workbook
workbook.save(dataDir + "HtmlWithoutHiddenContent_out.html", options)