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.
Back to
Seekers of Perl Wisdom