Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re^3: Reading excel file using PERL

by graff (Chancellor)
on Aug 19, 2009 at 03:01 UTC ( #789669=note: print w/replies, xml ) Need Help??


in reply to Re^2: Reading excel file using PERL
in thread Reading excel file using PERL

I don't know about Win32::OLE, but with Spreadsheet::ParseExcel, you have your choice of getting the (unformatted) "Val" or the (formatted) Value for each cell (and you'll want to choose the latter, though the date format you get will depend on how the spreadsheet was set up). Using the module's OO-style interface, it's a difference between a hash value and a method call:
#!/usr/bin/perl use strict; use warnings; use Spreadsheet::ParseExcel; my $Usage = "Usage: $0 filename.xls\n"; die $Usage unless ( @ARGV == 1 and -f $ARGV[0] ); my $xcl = Spreadsheet::ParseExcel::Workbook->Parse( $ARGV[0] ); for my $sheet ( @{$xcl->{Worksheet}} ) { printf( "Sheet: %s\n", $sheet->{Name} ); for my $row ( $sheet->{MinRow} .. $sheet->{MaxRow} ) { for my $col ( $sheet->{MinCol} .. $sheet->{MaxCol} ) { my $cell = $sheet->{Cells}[$row][$col]; printf( " row %s, col %s: unformatted= %s, formatted= %s\n +", $row, $col, $cell->{Val}, $cell->Value ); } } }

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://789669]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (7)
As of 2017-11-23 23:17 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:













    Results (343 votes). Check out past polls.

    Notices?