Re^4: Help with Excel::Table

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!

Comment on Re^4: Help with Excel::Table

Replies are listed 'Best First'.
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]

Replies are listed 'Best First'.

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]