Re: CPAN modules to read xlsx file in v.5.6

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.

Comment on Re: CPAN modules to read xlsx file in v.5.6

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