Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
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.

Comment on Parsing large excel file
Download Code
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 the web crawler heard nothing...

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

    The best computer themed movie is:











    Results (294 votes), past polls