Conversion to HTML results in large file of several MB

Aspose.Cells Product Family
,
1

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);

2

@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
3

@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.