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