Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re^2: Reducing the memory usage of Spreadsheet::ParseExcel

by cibien (Novice)
on Jan 21, 2013 at 14:53 UTC ( #1014457=note: print w/ replies, xml ) Need Help??


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

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 :(


Comment on Re^2: Reducing the memory usage of Spreadsheet::ParseExcel
Download Code
Re^3: Reducing the memory usage of Spreadsheet::ParseExcel
by cibien (Novice) on Jan 23, 2013 at 07:27 UTC
    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://1014457]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (4)
As of 2014-09-20 08:22 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

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











    Results (157 votes), past polls