Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
35
Exporting large amounts of data to Excel 2007 format
posted

I'm trying to export  large amount of data, let's say  100 000 rows with 12 cols. Unfortunately this process consumes far too much memory. While memory taken to fill workbook with data is acceptable, when I call Workbook.Save() memory usage goes through the roof. Is there any way to write file in chunks, stream data to disk or maybe some other possibility to decrease amount of memory taken by saving the file?

Parents
No Data
Reply Children
No Data