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