.
...
ExcelWriter is a powerful tool for generating and manipulating Excel files. The files are generated in memory then saved to disk or streamed them to the user over HTTP. In order to provide maximum flexibility for manipulating every element of a spreadsheet, ExcelWriter (in particular ExcelApplication) has a rich object model that must be populated at runtime and requires sufficient memory.
| Excerpt |
|---|
It is important to understand that the memory required to process a large report is much greater than the size of eventual output file. |
In the ExcelApplication object , every cell "hydrated" by our object model requires up to 400 bytes of memory for the various objects associated with each cell for values, formulas, formatting, etc. The number of cells equals the number of rows times the number of columns. So if you have a large report with 50,000 rows by 20 columns, that's 1 million cells and it can use up 300-400 MB of memory to process just one request for that report.
...