Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses
 
PerlMonks  

Re^3: Spreadsheet::ParseXLSX or Spreadsheet::ParseExcel doesn't work with .xlsx

by Tux (Canon)
on Oct 20, 2020 at 07:41 UTC ( [id://11123016]=note: print w/replies, xml ) Need Help??


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
    Thank you for the answer!

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://11123016]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others learning in the Monastery: (8)
As of 2024-04-16 08:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found