I’m using Aspose.Cells to create some large Excel files (400,000+ rows) and I was wondering what the quickest way to save/create the files would be. Creating the Aspose workbook object and populating it with data goes quickly, but my problem currently is that running the workbook.Save() function can take a long time. For 400k rows, this can take 75 seconds or longer.
Thanks for your posting and using Aspose.Cells.
Please download and try the latest version: Aspose.Cells for .NET 8.2.2 we have incorporated lot of performance improvements in the recent versions and also we have recently improved the performance of reading of large Excel files.
Please also create a standalone console application project with the latest version that shows the performance issue on saving the Excel file. For example, you can create a large dataset and import the data inside it using the approach mentioned in this article
and then compare the performance difference of saving the final Excel file. We will run the application at our end and observe it and provide it to development team so that performance on saving could be investigated and improved.
Thanks for your cooperation.