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.