in reply to Re^2: Spreadsheet::ParseXLSX or Spreadsheet::ParseExcel doesn't work with .xlsx
in thread Spreadsheet::ParseXLSX or Spreadsheet::ParseExcel doesn't work with .xlsx
You need to have the real parser installed. Spreadsheet::Read is just a unifying frontend API to all the supported parsers. This is like using DBI without knowing what DBD is used: your programm does use DBI; and DBI->connect decides what DBD to load. Likewise for Spreadsheet::Read.
So to parse .xslx you have to install Spreadsheet::ParseXLSX and then you do somthing like:
use strict; use warnings; use Spreadsheet::Read; my $book = Spreadsheet::Read->new ("file.xlsx"); my $sheet = $book->sheet (1); my $a3 = $sheet->cell ("A3");
Enjoy, Have FUN! H.Merijn
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^4: Spreadsheet::ParseXLSX or Spreadsheet::ParseExcel doesn't work with .xlsx
by farahk22 (Initiate) on Oct 23, 2020 at 08:34 UTC |
In Section
Seekers of Perl Wisdom