http://www.perlmonks.org?node_id=997923


in reply to Re: Out of memory and While replacements with excel XLSX application
in thread Out of memory and While replacements with excel XLSX application

This answer was the first one I succefully implemeted. It was a solution to the original question of how to avoid a "out of memory" return, while still writing to .XLSX files. Thanks to the poster.

The total system memory use never exceeded 4GB as before and the total runtime seemed unchanged.

I will test some the other solutions to see if the runtime can be optimized through better coding on my part.