I'm building spreadsheet report in Excel 2007 format in my code. When the excel file is saved, the size of the file is huge. When I opened the saved file, and resaved it, the file size was reduced by a lot. Is there a way to reduce the file size programmatically using VB?
I tried the same thing in Excel 2003 format, and the file size of the file is much smaller.
Appreciate your feedback.
There is no way to programmatically reduce this file size. However, this is a bug and has been fixed as part of the fix for issue TFS14252. You can submit this issue to the support group and reference the issue number to be notified when the hotfix is released: http://es.infragistics.com/gethelp.