Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl-Sensitive Sunglasses

How to read Excel 2007 XLSX format?

by zeno (Friar)
on Mar 05, 2007 at 19:26 UTC ( #603281=perlquestion: print w/replies, xml ) Need Help??

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.

Replies are listed 'Best First'.
Re: How to read Excel 2007 XLSX format?
by Joost (Canon) on Mar 05, 2007 at 20:18 UTC
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
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;

    Edit: g0n - altered link to prevent display of very long url

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://603281]
Approved by GrandFather
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chanting in the Monastery: (7)
As of 2022-05-16 08:58 GMT
Find Nodes?
    Voting Booth?
    Do you prefer to work remotely?

    Results (62 votes). Check out past polls.