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

Hi!!! I hav XML files and, i m looking for a way to convert them into Excel format using perl. Can any one tell me a way to do so. Thanks, Nidhi

Replies are listed 'Best First'.
Re: XML to Excel Converter
by dHarry (Abbot) on Feb 06, 2009 at 08:21 UTC

    I depends on the complexity of your XML file. If the XML is not too complex (table like) I suggest you first take a look at Spreadsheet::WriteExcel::FromXML and related modules. This seems to do exactly what you want. If on the other hand your XML file is complex you probably have to write it yourself. You can combine an XML parser and an Excel writer for that. There are several modules available on CPAN.

Re: XML to Excel Converter
by 1Nf3 (Pilgrim) on Feb 06, 2009 at 07:16 UTC
Re: XML to Excel Converter
by mirod (Canon) on Feb 06, 2009 at 08:31 UTC

    It depends what kind of Excel file you need to deliver. Usually I generate tab separated files, and everybody is happy, the users because they can import them seamlessly into Excel, and me because I can read them with a text editor. You can use pretty much any XML module to deliver that format.