Reduce the Output size of Excel

Aspose.Cells Product Family
1

Hi All


I have an excel with size 2MB. Is there a way to reduce the size of the excel. I have attached the sample excel. Thanks in advance.

Thanks
Rangaraj
2

Hi,


Thanks for your query with template file.

Well, I am afraid there is is no way to do it for Excel spreadsheets (e.g XLSX. XLS, etc.) if you want to keep all the data in tact at the same time. You may do that to certain extent if you are rendering the spreadsheet to PDF file format via PdfSaveOptions.setOptimizationType() method to set to minimum size, you may also try to use PdfSaveOptions.setImageResample() method if you need do resampling of images. By the way, for XLSX file format, removing the cell name may decrease the file size if there are lots of cells, you may accomplish it via OOxmlSaveOptions.setExportCellName() method.

Thank you.