Re^3: 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]