'Out of memory' issue even with cell handler.

[Pankaj SY]

Hi,

I am getting 'Out of memory' issue even with cell handler.
I saw in the task manager that initial memory consumption of a 92.5 MB
excel file goes to more than 820 MB.

What to do ?


Regards,
Pankaj Singh

[jmcnamara]

On Jan 9, 12:44 pm, Pankaj SY <pankaj.i...@gmail.com> wrote:
> Hi,
>
> I am getting 'Out of memory' issue even with cell handler.
> I saw in the task manager that initial memory consumption of a 92.5 MB
> excel file goes to more than 820 MB.
>
> What to do ?

Hi Pankaj,

Try Spreadsheet::ParseExcel::Stream. It is designed to reduce memory
usage:

http://search.cpan.org/~dougw/Spreadsheet-ParseExcel-Stream/Stream.pm

Regards,

John.
--