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?

  • 1176
    posted

    here is the solution for the hotfix, hope this solves your problems

  • 1176
    posted

    sorry for  adding this to your post but there is no reason to open a new one and both can be be help at same time

    also same problem but also read there is a service release to fix this, how can i downloaded? i just went to my ig downloads and only show me my infragystic program but no releases

    Thanks.