Converting XML to Excel

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

Replies are listed 'Best First'.
Re: Excel by Mr. Muskrat (Canon) on Jun 15, 2002 at 20:40 UTC
The following modules will do it quite nicely. XML::Parser Spreadsheet::WriteExcel Who says that programmers can't work in the Marketing Department? Or is that who says that Marketing people can't program?	[reply]
Re: Excel by cacharbe (Curate) on Jun 15, 2002 at 21:27 UTC
And if you happen to be working in a Windows environment, You can always use Win32::OLE and here's a primer. As far as XML goes, XML::LibXML, XML::Simple are but two of a flock of good choices, though without seeing an example of your data, it's difficult to make a suggestion. C-.	[reply]
Re: Converting XML to Excel by dree (Monsignor) on Jun 16, 2002 at 08:46 UTC
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	[reply]