Free Support Forum - aspose.com

Conversion to HTML results in large file of several MB

Conversion of xlsx with filters results in HTML several MB in size.

Here is conversion code. Attached is the original xlsx and html

sample.zip (118.2 KB)

Workbook workbook = new Workbook(sourceFilePath);
HtmlSaveOptions options = new HtmlSaveOptions();
options.setDisableDownlevelRevealedComments(true);
options.setExcludeUnusedStyles(true);
options.setExportComments(false);
options.setHiddenColDisplayType(HtmlHiddenColDisplayType.HIDDEN);
options.setHiddenRowDisplayType(HtmlHiddenRowDisplayType.HIDDEN);
options.setExportBogusRowData(true);
options.setExportFrameScriptsAndProperties(false);
options.setWidthScalable(false);
options.setExportHeadings(true);
workbook.save(“C:\AsposeSheets\”+“test.html”, options);

@cary.arvidson,
We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-47864 - Conversion to HTML results in large file of several MB

@cary.arvidson,
In the file named “long.xlsx”, the cell named “XFA11” has a string value(“v”).
The max display range is Sheet1!A1:XFA18.
So the output html will have many columns.
If the cell named “XFA11” is not necessary, please check it and delete it.

Can you try it?
Let us know your feedback.