in reply to Re: Out of Memory while using Spreadsheet::XLSX
in thread Out of Memory while using Spreadsheet::XLSX

Hi all, glad to have all the responses from all you guys :). I'm using ParserExcel for .xls files but this is unable to parse .xlsx files. So I'm using Spreadsheet::XLSX. I have decided to use this module after a lot of R&D, this was the only way I found out which worked for me, but after testing this on large files it takes hell lot of memory for files of 5MB. Is there any way to minimize it as there is cell_handler in ParseExcel??

  • Comment on Re^2: Out of Memory while using Spreadsheet::XLSX

Replies are listed 'Best First'.
Re^3: Out of Memory while using Spreadsheet::XLSX
by Anonymous Monk on Jul 11, 2014 at 05:56 UTC

    Hi runring, I'm really so sorry I didn't get what you said...Could you please explain it?

[reply]
      Which part don't you get? And are you actually running out of memory, or just using a lot of memory? Yes, this library uses a lot of memory on large files, nothing you can do about it, no CellHandler or any such thing. But you are saving rows of the file to an array. If you're running out of memory, at what point in the program are you running out?
[reply]

        Hi runrig, as a anonymous monk I published this problem. Since I created my account I will reply as perl_new_b. I'm saving each row into an array but after writing that array to a files I flush it using @Row = ();. I'm running out at new.

[reply]

In Section Seekers of Perl Wisdom