Skip to Content
0
Former Member
Apr 05, 2011 at 06:01 PM

Export to excel sizing issue

471 Views

Hi there,

we are facing a weired issue when using export to excel from the query output, we have notice that while we save the excel it is getting saved as a HUGE file irrespective of the data volume.

For ex:our report has 1100 records, but when we export to excel it got saved as a 7MB file..

However when we save the file as CSV, it work okay.. wondering why are we facing an issue while export to excel ?? Is there any way that we can set the Excel format options in query output??

I've tried searching in forums, couldn't find the solutions, Please could any one throw some light on this??

Regards,

J