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