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?
here is the solution for the hotfix, hope this solves your problems
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.