Beefy Boxes and Bandwidth Generously Provided by pair Networks
Don't ask to ask, just ask

Re: Out of Memory while using Spreadsheet::XLSX

by sn1987a (Chaplain)
on Jul 10, 2014 at 12:43 UTC ( #1093049=note: print w/replies, xml ) Need Help??

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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1093049]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (9)
As of 2020-02-25 13:35 GMT
Find Nodes?
    Voting Booth?
    What numbers are you going to focus on primarily in 2020?

    Results (110 votes). Check out past polls.