in reply to Out of Memory while using Spreadsheet::XLSX

,p>I don't know about Spreadsheet::XLSX but Spreadsheet::ParseExcel, on which it is modeled, has the ability to specify a cell handler. This avoids the need to store the entire parsed spreadsheet. You just the extract the data you need as it is being parsed.

Its use in controling memory usage is discussed in the documentation at Spreadsheet::ParseExcel#Reducing-the-memory-usage-of-Spreadsheet::ParseExcel

Update: Added a little more expanation

Replies are listed 'Best First'.
Re^2: Out of Memory while using Spreadsheet::XLSX
by runrig (Abbot) on Jul 10, 2014 at 21:42 UTC
      Thanks for the update runrig. I was unable to check that at the time I made my response.