Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: Reducing the memory usage of Spreadsheet::ParseExcel

by Corion (Pope)
on Jan 21, 2013 at 12:59 UTC ( #1014440=note: print w/ replies, xml ) Need Help??


in reply to Reducing the memory usage of Spreadsheet::ParseExcel

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.


Comment on Re: Reducing the memory usage of Spreadsheet::ParseExcel
Re^2: Reducing the memory usage of Spreadsheet::ParseExcel
by Neighbour (Friar) on Jan 21, 2013 at 14:10 UTC
    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).
Re^2: Reducing the memory usage of Spreadsheet::ParseExcel
by cibien (Novice) on Jan 21, 2013 at 14:53 UTC
    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 :(
      Nothing? please help me
        Like, put it where you have  Spreadsheet::ParseExcel->new , replace one ->new with another ->new

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1014440]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others avoiding work at the Monastery: (10)
As of 2014-09-19 09:28 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    How do you remember the number of days in each month?











    Results (133 votes), past polls