Re: Reducing the memory usage of Spreadsheet::ParseExcel

[Corion]

Have you looked at the Spreadsheet::ParseExcel section on Reducing the memory usage of Spreadsheet::ParseExcel? What parts of it do you have problems with?

This is not a code writing service. If you have problems with your Perl code or with applying the information to your Perl code, you will have to tell us where exactly you have problems.

[cibien]

Thanks for answer. yes I looked section on "Reducing the memory usage of Spreadsheet::ParseExcel" but I'am novice in Perl and I don't know how put this code:

    #!/usr/bin/perl -w

    use strict;
    use Spreadsheet::ParseExcel;

    my $parser = Spreadsheet::ParseExcel->new(
        CellHandler => \&cell_handler,
        NotSetCell  => 1
    );

    my $workbook = $parser->parse('file.xls');

    sub cell_handler {

        my $workbook    = $_[0];
        my $sheet_index = $_[1];
        my $row         = $_[2];
        my $col         = $_[3];
        my $cell        = $_[4];

        # Do something useful with the formatted cell value
        print $cell->value(), "\n";

    }

and how adapt it for my code. I have spend a lot of hours but nothing... help me please :(

[cibien]

Nothing? please help me

[Anonymous Monk]

Like, put it where you have  Spreadsheet::ParseExcel->new, replace one ->new with another ->new

[Neighbour]

Yea, tried that..see my scratchpad under Excel reading issues.
It didn't save nearly enough memory (a 45MB xls still needed around 300MB memory to load) (which you confirmed :P).