Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: Converting XML to Excel

by dree (Monsignor)
on Jun 16, 2002 at 08:46 UTC ( #174908=note: print w/ replies, xml ) Need Help??


in reply to Converting XML to Excel

If you can use a DBMS, you can do this:

1) convert your XML file in a SQL table (using your preferred DBMS) with xml2sql.pl that you can find on CPAN bundled with the module DBIx::XML_RDB.
2) convert the SQL table from the DBMS to an Excel spreadsheet with the module Spreadsheet::WriteExcel-FromDB also available on CPAN.

If you can not use a real DBMS, maybe DBD::RAM or DBD::SQLite would work for you.

Also xml2sql.pl could work directly with DBD::Excel


Comment on Re: Converting XML to Excel

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (7)
As of 2015-07-28 08:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (254 votes), past polls