How to read Excel 2007 XLSX format?

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

I just received some Excel 2007 files to read into a database. The files are in the new XLSX compressed XML format. Is there a Perl module for reading this new format?

In case you think of it, I did download the tool for converting back to 2003 format, but the pahtk who sent me the file put more that 65000 rows in it, so Excel 2003 can't read all of them.

-- zeno - http://www.timallen.org

Comment on How to read Excel 2007 XLSX format?

Replies are listed 'Best First'.
Re: How to read Excel 2007 XLSX format? by Joost (Canon) on Mar 05, 2007 at 20:18 UTC
SpreadSheet::WriteExcel has a section on modules you can use to read excel. SpreadSheet::ParseExcel is fairly recent so it might work. Otherwise, if you have excel 2007, you can always export the sheet as CSV and use Text::xSV or something similar to read it. update: in a pinch, it might be worth checking out the data in the file. Since it's XML it should be more readable (once uncompressed) than the previous formats. Note that I have zero experience with office 2007 formats, so I might be talking complete bollocks. :-) "What should it profit a man, if he should win a flame war, yet lose his cool?"	[reply]
Re: How to read Excel 2007 XLSX format? by Tux (Canon) on Mar 05, 2007 at 21:04 UTC
Maybe, just maybe, Spreadsheet::ReadSXC can handle it. It is the OpenOffice spreadsheet reader, and OO is XML. Being the author of Spreadsheet::Read, I'd be rather interrested in having a Excel2007 file to check on that Enjoy, Have FUN! H.Merijn	[reply]
Re: How to read Excel 2007 XLSX format? by zeno (Friar) on Mar 06, 2007 at 17:04 UTC
In the end, I was able to download the Microsoft Data Provider for this from Microsoft. The solution is non-Perl, but if you need it, the connection string is of the form: `Data Source=D:\Test.xlsx;Provider=Microsoft.ACE.OLEDB.12.0; Extended P +roperties=Excel 8.0;` [download] -- zeno - http://www.timallen.org Edit: g0n - altered link to prevent display of very long url	[reply] [d/l]


Just another Perl shrine
	PerlMonks