Perl Module - Spreadsheet::Read

From Torben's Wiki

see [1] or [2]


moved to Perl#Read_Excel


Install via

perl -MCPAN -e "install Spreadsheet::Read"

Example

use Spreadsheet::Read;
my $book  = ReadData ("test.xls"); # .ods .csv .xls .xlsx
my $book  = ReadData ($fh, parser => "xls");
 
my $sheet = $book->[1];             # first datasheet
my $cell  = $book->[1]{A3};         # content of field A3 of sheet 1
my $cell  = $book->[1]{cell}[1][3]; # same, unformatted