in reply to Out of memory problem in Windows XP 32-bit: only 1GB occupied
Thanks! I appreciate the insights.
The original Excel XLSX file is only 123MB but it has one spreadsheet with 1 million rows. As I would expect, the Perl modules use more memory than the XLSX file size, probably due to hashes.
I understand that it is a very large file for Excel but that is what the client is bringing.
I'm leaning towards reading the file with another language (Java maybe) and convert it into text and then read it with Perl. Convoluted unfortunately. I will also check the Win32::OLE suggestion.
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^2: Out of memory problem in Windows XP 32-bit: only 1GB occupied
by marto (Cardinal) on Feb 01, 2013 at 14:10 UTC | |
Re^2: Out of memory problem in Windows XP 32-bit: only 1GB occupied
by BrowserUk (Patriarch) on Feb 01, 2013 at 14:17 UTC | |
Re^2: Out of memory problem in Windows XP 32-bit: only 1GB occupied
by dasgar (Priest) on Feb 01, 2013 at 14:21 UTC |
In Section
Seekers of Perl Wisdom