Re: Out of Memory

If all else fails, you might have to use XML::Twig and do the XML parsing of the XLSX sheet yourself. This will mean taking much of the extraction code of Spreadsheet::XLSX and remunging it into a callback-based interface (like Spreadsheet::ParseExcel)...

Comment on Re: Out of Memory

Replies are listed 'Best First'.
Re^2: Out of Memory by ETLTCHFIG (Novice) on May 05, 2011 at 16:18 UTC
First up thanks a lot for the ideas! So there is no way around rewriting the code to overcome this out-of-memory error? I mean as a quick fix? Not trying to be lazy; I ask as this is holding Production already - if I could do something to get this piece going in the interim, I could take time out to rewrite, test and promote the rewritten version. Any ideas?? ulimit -a shows the following - `fdrread@laatdm62:/home/fdrread> ulimit -a time(seconds) unlimited file(blocks) unlimited data(kbytes) unlimited stack(kbytes) 4194304 memory(kbytes) unlimited coredump(blocks) unlimited nofiles(descriptors) unlimited` [download] Again, THANKS A TON!	[reply] [d/l]

Replies are listed 'Best First'.

Re^2: Out of Memory
by ETLTCHFIG (Novice) on May 05, 2011 at 16:18 UTC

First up thanks a lot for the ideas! So there is no way around rewriting the code to overcome this out-of-memory error? I mean as a quick fix?

Not trying to be lazy; I ask as this is holding Production already - if I could do something to get this piece going in the interim, I could take time out to rewrite, test and promote the rewritten version.

Any ideas??

fdrread@laatdm62:/home/fdrread> ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         unlimited
stack(kbytes)        4194304
memory(kbytes)       unlimited
coredump(blocks)     unlimited
nofiles(descriptors) unlimited
[download]

[reply]
[d/l]