Reduce size of exported excel report

[SGD]

Hi,

How can we reduce the size of excel exported report? I have 29002 rows in the report which creates 84MB of excel file when I export the same using Excel 2002 option.

Please suggest.

[SGD]

Observed that same report generated in Excel 2007 format has less size (4MB) than Excel 2002 format.

However, user use MS Office 2003 Professional edition hence need to export report in Excel 2002 option only.

[Peewee71]

When you export to excel cognos uses a verbose xml based format, hence why your file is so much bigger.

I believe this was mitigated in version 8.4  and beyond. Which version of cognos are using?

My solution that i needed to take was export as a csv.  You may lose format if you choose this option.

[SGD]

Hi Peewee71,

I am using Cognos 8.4.1 version.

No idea why size of the file is big. report has 29002 rows and it might increase also however exported in Excel 2002 format it generates 84MB excel file and in Excel 2007 format it generates 4MB excel file.

Can not use .csv format because as you said I need to maintain the formatting of report as it is.