Open/Save large excel file

Hello,

We create a huge excel file using SSIS. The file size is about 150MB. When creating excel files with SSIS, it usually is the double of the file instead of what its supposed to be. To fix this, we usually open the file and press save and the file size reduces automatically to 50%. Now since I do not want to do this manually, I thought I could simply use aspose to open the file and save it right after. This works fine, and the file size shrinks as well to 50%, however I notice that its using a lot of memory. Is there a way to solve my described problem above without opening the file?

Thanks

Hi,

Well, when you load such an excel file with 150MB in size or more, generally, the process will consume a lot of memory to open and then save as the file. Anyways, we will check it and get back to you soon.

Thank you.