Re^3: Help with Excel::Table


Do you know where your variables are?
	PerlMonks

Re^3: Help with Excel::Table

by Athanasius (Archbishop)

on Sep 26, 2020 at 09:10 UTC ( [id://11122234]=note: print w/replies, xml )

Need Help??

in reply to Re^2: Help with Excel::Table
in thread Help with Excel::Table

Thanks for the SSCCE. As toolic says, the error (really just a warning) message appears to relate to Log::Log4perl; the Excel workbook is being opened correctly.

The example code in the SYNOPSIS section of the documentation for Excel::Table doesn’t seem to work for me. If you have difficulty using this module, you’ll probably be better off directly using Spreadsheet::XLSX — which you already have, since it’s used by Excel::Table!

Cheers,

Athanasius <°(((>< contra mundum Iustus alius egestas vitae, eros Piratica,

Comment on Re^3: Help with Excel::Table Select or Download Code

Replies are listed 'Best First'.
Re^4: Help with Excel::Table by BernieC (Pilgrim) on Sep 26, 2020 at 11:34 UTC
Thanks for the update. It hadn't occurred to me that the "warning" was nothing, I guess it'd be a bug in Excel::Table -- it isn't calling the log4perl->init {or easy_init()} What attracted me to Excel::Table is that it does exactly what I want: turns workshets into arrays. I'll investigate Spreadsheet::XLSX. Thanks!	[reply]
Re^5: Help with Excel::Table by Tux (Canon) on Sep 26, 2020 at 12:40 UTC
DON'T !!!!! DO NOT USE Spreadsheet::XLSX! Use Spreadsheet::ParseXLSX if you want to stay close to the data. If you need a unified API that works for `xls`, `xlsx`, `csv`, `sxc`, and `ods`, check out Spreadsheet::Read, which uses Spreadsheet::ParseXLSX under the hood for the hard work. I cannot stress this enough: Spreadsheet::XLSX is dead. It is no more. It ceased to exist. It rests in peace. Enjoy, Have FUN! H.Merijn	[reply] [d/l] [select]

In Section Seekers of Perl Wisdom

Domain Nodelet^?

www.com | www.net | www.org

Node Status^?

node history
Node Type: note [id://11122234]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others having a coffee break in the Monastery: (5)

As of 2024-04-19 22:50 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Today I Learned

Voting Booth^?

No recent polls found