Re: 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 Reducing-the-memory-usage-of-Spreadsheet::ParseExcel of Spreadsheet::ParseExcel

Update: Added a little more expanation

Comment on Re: Out of Memory while using Spreadsheet::XLSX Select or Download Code

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
Spreadsheet::ParseExcel parses XLS files, not XLSX files. Spreadsheet::XLSX does not have the same sort of memory-saving cell handler functionality.	[reply]
Re^3: Out of Memory while using Spreadsheet::XLSX by sn1987a (Curate) on Jul 11, 2014 at 12:29 UTC
Thanks for the update runrig. I was unable to check that at the time I made my response.	[reply]