in reply to Re^3: Out of Memory
in thread Out of Memory

OK - I THINK I GOT THE PROBLEM - In XLSX.pm the method new issues the following read foreach ($member_sheet -> contents =~ /(\<.*?\/?\>|.*?(?=\<))/g) { This is trying to cache the whole worksheet at a time; one of my worksheets in the XLSX file that is throwing the "Out of Memory" has a million rows Is there a way I can change this to perform line by line reading?

Replies are listed 'Best First'.
Re^5: Out of Memory
by vkon (Curate) on May 06, 2011 at 06:17 UTC
    optimizing such kind of constructs - is one of the ways in your situation.

    The answer to your question - 'yes',

[reply]

In Section Seekers of Perl Wisdom