We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Excel export

Hi,

We are trying to understand if your product works for us. We are dealing with huge amount of data and exporting 200000 rows with 100 columns. We need performance and good memory consuption.. Do you have any test results or performance charts..

Thanks

Altay Karakuş


This message was posted using Email2Forum by ShL77.

Hi,

Well, if you want to fill 200000 * 100 records in a single worksheet and save/create the Excel file, the process would surely require huge amount of memory and it does take some time to be completed. Also, the generated Excel file (e.g XLSX) would be huge in size. Aspose.Cells for .NET is capable of importing exporting huge list of data and can perform the task if you got sufficient resources. I think it would be better if you could split your data into multiple worksheets, it would surely enhance the performance to certain extent.

We have a benchmark document/article which does show the results in certain scenarios/cases. It also shows the results of some other components/products (from the market) using the similar scenarios/cases: http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/aspose-cells-and-competitors-performance-matrics-and-benchmarks.html

I am also attaching here our latest fix/version here, so you could try it for your scenario. Please try it and let us know if it works fine for you. If you find any issue, kindly let us know with the details, we will check it soon.

Thank you.