I'm testing generation of pivot tables. Attached you find example code to test the time to generate a pivot table. There are two variable factors; the number of rows read from the datasource and the number of rows in the pivot(PivotFieldType.Row)
Attached you also find an Excel document with a graph describing the time used on my computer during a "non-scientific" test. As you see, the time increases exponentially when I add more rows.
When using 3 pivot rows the generation also throws an "Invalid column index" when the number of rows from datasource exceeds 20-30 000 records.
I'm using version 5.3.1.0 of the Aspose.Cells.dll.
Do you have plans to make the algorithm for generating pivot with several rows more efficient? In Excel you can drag'n drop as you like with no delay!
Do you have plans to fix the exception thrown?
Regards,
Kristian
Hi,
I tested your project a bit. I find the issue, it takes more time
when we add more pivot rows e.g 3 pivot rows with huge list of data source records. I tested it with our latest version v5.3.2 which we released it now. I have logged it with an id: CELLSNET-26050 for enhancement.
You may try our latest version Aspose.Cells for .NET v5.3.2 if it enhances the process. And, we will continue to look into your issue to sort it out.
Thank you.
Hi,
Please try Aspose.Cells for .NET v5.3.2.3, we have improved the performance for your issue now. Could you try and let us know your feedback.
Thank you.
I have downloaded version 5.3.2.3 and tested it. The performance has improved remarkably :-).
One of my test scenarioes has reduced the time from 150 to 10 seconds.
Another scenario which previously failed with "Invalid column index" after 241 seconds, is now completed in 16 seconds.
Thank you very much!
Regards,
Kristian
Hi,
Thanks for sharing your feedback.
Good to know that your issue is resolved.
Have a good day!