Hi!
I am trying to output large quantities of data in a single worksheet via Aspose.Cells. The data is mostly strings and numbers without any formatting (yet). I happen to come across two troubling facts:
- When outputting the values to XLS file format, the file generation is very fast - around 10sec. However, when the same amount of data is stored in XLSX format, the same amount of data is saved in around 2 minutes. Why is there such discrepancy?
- I have also compared two versions of Aspose.Cells: 4.8.2.0 with 7.2.2.0, but with greater amount of data (more than 65536 rows). The older version is outputting XLSX almost two times faster than the new one.
Tests were done on Windows 7 with search indexing feature turned off.
Because of the data limit of XLS, XLSX is preferable, but the time to save such file is too long.
Could you shed some light on what could be the reason for these differences and what could be done to speed things up?
Regards
Tomasz Męciński