Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl: the Markov chain saw
 
PerlMonks  

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.

Comment on How to read Excel 2007 XLSX format?
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 (Monsignor) 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

Reaped: Re: How to read Excel 2007 XLSX format?
by NodeReaper (Curate) on Apr 29, 2008 at 07:44 UTC

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (13)
As of 2014-10-02 14:30 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    What is your favourite meta-syntactic variable name?














    Results (61 votes), past polls