Aspose.Cells and Excel 2007

Aspose.Cells Product Family
1

I am running some tests between Excel Automation and Aspose.Cells using Excel 2007 XLSX files. I am creating a file that has 5 sheets with each sheet cointaing 20 columns and 65,003 rows. Excel Automation is able to save this file in 30 seconds and open the file in 30 seconds while Aspose.Cells is taking 2 minutes to save the file and over a minute to open the file. Why is Aspose.Cells so slow when working with XLSX files? If I do the same tests with Excel 2003 files Aspose.Cells saves the file in 9 seconds and opens it in 11 seconds. When will XLSB support be added?

2

Hi,

Thanks for providing us the info. We will look into the XLSX performance issue and get back to you.

We are working on XLSB but I am afraid it will not be available recently.

Thank you for your patience.

3

Hi,

Please try the attached version. We have optimized reading/writing xlsx format file. Now creating or reading a file that has 5 sheets with each sheet containing 20 columns and 65,003 rows in xlsx format may take 30~40 seconds. Hope this can meet your need. Thank you.