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