CPAN modules to read xlsx file in v.5.6

Arunkumar_141 has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: CPAN modules to read xlsx file in v.5.6 by Anonymous Monk on Sep 22, 2018 at 19:16 UTC
No you dont :) xlsx didnt exist in times of perl 5.6 http://cp5.6.1an.barnyard.co.uk	[reply]
Re: CPAN modules to read xlsx file in v.5.6 by Anonymous Monk on Sep 24, 2018 at 15:38 UTC
Didn't Win32:OLE exist in those days? There is a long history of that module reading Excel files. .xlsx is essentially a zipped version of .xls , so it is a bit different. And maybe I could access .xlsx files in OLE due to have the Excel program on my computer. I don't think OLE can create an .xlsx file, but it might be able to access it for reading. (See notes in the PerlMonks tutorials for some guidance on that.) Warning. I didn't test this, or research it deeply. This is just a thought.	[reply]
Re^2: CPAN modules to read xlsx file in v.5.6 by marto (Cardinal) on Sep 27, 2018 at 06:42 UTC
If you have Excel installed on your machine I think you shouldn't have any problems automating it with Win32::OLE to do what you want.	[reply]
Re^2: CPAN modules to read xlsx file in v.5.6 by Anonymous Monk on Sep 26, 2018 at 23:18 UTC
.xlsx is a completely different format from .xls, it's XML based.	[reply]
Re: CPAN modules to read xlsx file in v.5.6 by RonW (Parson) on Sep 26, 2018 at 19:55 UTC
If you can't find a compatible module on https://metacpan.org, you might be able to find one on http://backpan.cpantesters.org	[reply]