Free Support Forum - aspose.com

Performance degrades when having more than 3 tabs

Hi,

I am using Aspose.Cells 4.5 for .NET and found that the performance degrades exponentially when tab number increases. I use ImportDataTable to copy the dataset.

I need to fill in each tab with 65535 rows. When I have 3 tabs, it's taking 94 seconds, and 4 tabs take 331 seconds. When I have 5 tabs, it throws "OutofMemory" exception in the save() method.

Do you have a limit on the size of the dataset or the output file? Is there anyway to improve?

Thanks!

Miao

Hi,

No, we don't place any size restriction for dataset or output file produced. Well, when you fill three or more than three sheets each with 65k+ rows, huge amount of memory would be consumed and the size of the excel file would also be a huge one for your info. I think you should split 65k+ rows into multiple sheets or split your workbook to multiple workbooks (files), it would increase performance.

Thank you.