Perl Module - Spreadsheet::Read

From Torben's Wiki
Revision as of 11:21, 25 June 2018 by Torben (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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