XSLX file produced by Workbook.save() is huge

Aspose.Cells Product Family
1

I’m generating a multi-sheet XSLX file and then saving it with Workbook.save(). The resulting file is 70MB and takes about 30 seconds to open with Excel 2010. Resaving it from Excel results in an 11MB file that takes about 5 seconds to open.



Is there a way to save that results in a smaller file?

2
Hi,

Please try setting the OoxmlSaveOptions.setValidateMergedAreas(true), it will remove invalid records in the workbook and can minimize the size of the file.

We also recommend you to kindly try our latest version / fix in which we made enhancements: Aspose.Cells for Java v7.3.2.1

If you still find the issue, please paste your sample project/code (runnable) with the template file (if you have any). We will check your issue soon.

Thank you