Export to Excel from IE larger than from Chrome

Export to Excel from IE larger than from Chrome

tomcat14tomcat14 Posts: 20Questions: 6Answers: 1

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

  • allanallan Posts: 63,468Questions: 1Answers: 10,466 Site admin
    Answer ✓

    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

This discussion has been closed.