Re^3: memory usage Spreadsheet::ParseExcel

"the referenced object has been blessed into a package, then that package name is returned instead.

Switching from ref to Scalar::Util::reftype() would fix that.

and ::Worksheet warned on deep recursion and never came back up out of the stack

Using Scalar::Util::refaddr() with a %seen hash could prevent it recursing up its own bum.

The code I posted was by way of example. Just a blind tweak of a depth-first recursive structure traversal I had kicking around.

I'd have a go a making the above tweaks if I had a suitable example .xls file.

With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'

Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.

"Science is about questioning the status quo. Questioning authority".

In the absence of evidence, opinion is indistinguishable from prejudice.

Comment on Re^3: memory usage Spreadsheet::ParseExcel Select or Download Code

Replies are listed 'Best First'.
Re^4: memory usage Spreadsheet::ParseExcel by Anonymous Monk on May 15, 2012 at 00:23 UTC
BrowserUk (Pope) here you go then pardner http://specialprojects.invisionzone.com/index.php?/topic/10-memory-usage-spreadsheetparseexcel/	[reply]
Re^5: memory usage Spreadsheet::ParseExcel by BrowserUk (Patriarch) on May 15, 2012 at 00:47 UTC
Ignore this. It helps if you wait for the file to fully download before trying to parse it. 8{ <Reveal this spoiler or all in this thread> With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday' Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error. "Science is about questioning the status quo. Questioning authority". In the absence of evidence, opinion is indistinguishable from prejudice. The start of some sanity?	[reply] [d/l] [select]