Export to Excel from IE larger than from Chrome
Export to Excel from IE larger than from Chrome
I have been using Data Tables for a few months now and we are getting close to making this available to our customers but we just noticed some very odd behavior. If I run a report that returns 12,000 lines and export it to excel from Chrome the file is 1.4 MB. If I run the same report in IE and export it the file is over 14 MB. Does anyone have any idea why there is such a large difference between the file sizes from IE and Chrome? Is there a way to reduce the size from IE to be closer to the size from Chrome?
Thanks
This question has an accepted answers - jump to answer
Answers
Wow - that is a mega size difference!
They each use their own XML serialiser which results in different output, but I would only expect it to be a few bytes per row.
I'm afraid I don't have easy access to IE at the moment (Linux machine currently being used) - could you check to see if that also happens in this example for you?
Thanks,
Allan