Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
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 about the Monastery: (5)
As of 2017-04-30 01:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I'm a fool:











    Results (534 votes). Check out past polls.