in reply to Excel Parse Example - Program Hangs


Have a look at: Reducing the memory usage of Spreadsheet::ParseExcel and A different kind of Spreadsheet::ParseExcel memory problem..

As for the warning about wrapped characters, this is a known but unfixed bug. The usual workaround is to change the offending pack 'C*' to pack 'U*'

--
John.

  • Comment on Re: Excel Parse Example - Program Hangs

Replies are listed 'Best First'.
Re^2: Excel Parse Example - Program Hangs
by awohld (Hermit) on Dec 06, 2005 at 10:02 UTC
    Even though I run high on memory, the program completes.

    If I run out of memory is it possible that the program will complete and get messed up somehow and cause the probelm I'm seeing?

    If the Spreadsheet::ParseExcel::Simple goes out of scope each time in the foreach loop, is the object memory getting destroyed and recreated in each loop?

    Edit: Ahh I see that the memory isn't nescessarially deallocated when the object goes out of scope according to some of the links you suggested.
[reply]

In Section Seekers of Perl Wisdom