Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Parsing large excel file

by Anonymous Monk
on Oct 03, 2010 at 11:48 UTC ( #863169=perlquestion: print w/replies, xml ) Need Help??
Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

I'm trying to parse a large excel file - around 50MBytes (22 cols - unknown rows ).

I have tried Spreadsheet::ParseExcel, but it just hugs memory & cpu without doing anything ... even with a simple script like:

#!/usr/bin/perl -w use strict; use Spreadsheet::ParseExcel; $|++; my $parser = Spreadsheet::ParseExcel->new(); my $workbook = $parser->parse('1.xls'); if ( !defined $workbook ) { die $parser->error(), ".\n"; } my $worksheet = $workbook->worksheet(0); my $cell = $worksheet->get_cell(1,1); print "value: ", $cell->value();

My target is to load this info into MySQL if there's a simpler method I would appreciate it.

Replies are listed 'Best First'.
Re: Parsing large excel file
by Corion (Pope) on Oct 03, 2010 at 12:03 UTC

      Thanks, This has helped.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://863169]
Approved by marto
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others making s'mores by the fire in the courtyard of the Monastery: (2)
As of 2017-02-19 12:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Before electricity was invented, what was the Electric Eel called?






    Results (292 votes). Check out past polls.