Exclude Unused Styles during Excel to HTML conversion

Possible Usage Scenarios

Microsoft Excel file may contain many unused styles. When you export the Excel file to HTML format, these unused styles are also exported. This can increase the size of HTML. You can exclude the unused styles during the conversion of Excel file to HTML using the HtmlSaveOptions.ExcludeUnusedStyles property. When you set it true, all unused styles are excluded from output HTML. The following screenshot displays a sample unused style inside the output HTML.

todo:image_alt_text

Exclude Unused Styles during Excel to HTML conversion

The following sample code creates a workbook and also creates an unused named style. Since the HtmlSaveOptions.ExcludeUnusedStyles is set to true, so this unused named style will not be exported to output HTML. But if you set it false, then this unused style will be present inside the output HTML which you can then see in HTML markup as shown in the above screenshot.

Sample Code

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
//Create workbook
Workbook wb = new Workbook();
//Create an unused named style
wb.createStyle().setName("UnusedStyle_XXXXXXXXXXXXXX");
//Access first worksheet
Worksheet ws = wb.getWorksheets().get(0);
//Put some value in cell C7
ws.getCells().get("C7").putValue("This is sample text.");
//Specify html save options, we want to exclude unused styles
HtmlSaveOptions opts = new HtmlSaveOptions();
//Comment this line to include unused styles
opts.setExcludeUnusedStyles(true);
//Save the workbook in html format
wb.save("outputExcludeUnusedStylesInExcelToHTML.html", opts);