Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: Help with Excel::Table

by Tux (Canon)
on Sep 26, 2020 at 11:23 UTC ( #11122237=note: print w/replies, xml ) Need Help??


in reply to Help with Excel::Table

Note that Excel::Table currently depands on Spreadsheet::XLSX for modern Excel files (.xlsx). That module is completely unreliable, buggy and unmaintained and should be avoided at all costs. It was very useful at the time, but should be replaced with Spreadsheet::ParseXLSX as soon as possible.

Maybe Spreadsheet::Read offers an alternative to your wishes.

As your quest opens a .xlsx file, I felt compelled to make this note.

use Spreadsheet::Read; my $workbook = Spreadsheet::Read->new ("D:/myexcel.xlsx"); my $sheet = $workbook->sheet (1);

Enjoy, Have FUN! H.Merijn

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (2)
As of 2021-04-18 17:27 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?