note
jmcnamara
<p>The "out of memory" issue is probably caused by Excel::Writer::XLSX. Especially if you have 1 million rows.
</p>
<p>
You can reduce its memory usage (almost completely*) by setting the workbook <tt>set_optimization()</tt> method.
</p>
<code>
...
my $workbook = Excel::Writer::XLSX->new( file.xlsx' );
$workbook->set_optimization();
my $worksheet = $workbook->add_worksheet();
...
</code>
<p>
* See the [http://search.cpan.org/~jmcnamara/Excel-Writer-XLSX/lib/Excel/Writer/XLSX.pm#SPEED_AND_MEMORY_USAGE|Speed and Memory Usage] section of the Excel::Writer::XLSX docs for a full explanation.
</p>
<p>
--
<br>
John.
<br>
997733
997733