Re^2: memory usage Spreadsheet::ParseExcel

Tried it, no help, but great thanks anyway

"the referenced object has been blessed into a package, then that package name is returned instead. I added Spreadsheet::ParseExcel::

::Workbook

::FmtDefault

::Format

::Font

::Worksheet

as refs for Recursion. None seem to free memory and ::Worksheet warned on deep recursion and never came back up out of the stack

Comment on Re^2: memory usage Spreadsheet::ParseExcel

Replies are listed 'Best First'.
Re^3: memory usage Spreadsheet::ParseExcel by BrowserUk (Patriarch) on May 14, 2012 at 15:00 UTC
"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. The start of some sanity?	[reply] [d/l] [select]
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]