more useful options | |
PerlMonks |
Re: Out of memory and While replacements with excel XLSX applicationby jmcnamara (Monsignor) |
on Oct 08, 2012 at 10:02 UTC ( [id://997794]=note: print w/replies, xml ) | Need Help?? |
The "out of memory" issue is probably caused by Excel::Writer::XLSX. Especially if you have 1 million rows. You can reduce its memory usage (almost completely*) by setting the workbook set_optimization() method.
* See the Speed and Memory Usage section of the Excel::Writer::XLSX docs for a full explanation.
--
In Section
Seekers of Perl Wisdom
|
|