PERL AND XML

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

Hello Everyone,

I have a doubt in using XML in perl. I am trying to put an output of a perl script to an xml file. The idea being that the xml file can be opened in the MS excel spread sheet.

This is the print statement of the perl script.

foreach $app(keys %appsrvr) {
    print "\n$app";

    foreach $attribute(keys %{ $appsrvr{$app} }) {
        print "  $appsrvr{$app}{$attribute}";
    }
}
print "\n";
[download]

How do I put the above print stmt in an xml format file so that I can open the xml file in an excel spread sheet.

CODE tags added by Arunbear

Comment on PERL AND XML Download Code

Replies are listed 'Best First'.
Re: PERL AND XML by atcroft (Abbot) on Jul 30, 2005 at 18:13 UTC
Have you taken a look at the XML::Simple module? It includes an example in its docs for outputting data from a hash structure as XML. HTH.	[reply]
Re: PERL AND XML by sk (Curate) on Jul 30, 2005 at 18:08 UTC
XML::Writer Please use code tags when posting. You can find more info here Writeup Formatting Tips	[reply]
Re: PERL AND XML by pg (Canon) on Jul 30, 2005 at 19:36 UTC
If all what you wanted was to be able to open the file in Excel, XML is sort of over-engineered. Why not just go CSV file format?	[reply]
Re^2: PERL AND XML by BaldPenguin (Friar) on Jul 30, 2005 at 20:53 UTC
It depends on whether you want a spreadsheet or lines of data. Granted, most on the time lines of data work but saying CSV is a spreadsheet is like saying Excel is a database. With the right XML, you can also create functional cells (SUM, AVERAGE, etc. ) and with some work, PivotTables and Charts. Don WHITEPAGES.COM \| INC Everything I've learned in life can be summed up in a small perl script!	[reply]
Re: PERL AND XML by BaldPenguin (Friar) on Jul 30, 2005 at 20:50 UTC
You didn't say was format of XML, whether you are going with the basics or using ExcelXML, but this works for me. `use strict; use warnings; use XML::Element; my $root = new XML::Element('root'); foreach my $app ( keys %appsrvr ) { my $el = new XML::Element( $app , %{$appsrvr{$app}} ); $root->push_content($el); } print $root->as_XML();` [download] It's untested but should work. Currently I push all my xml to a really basic form, then use XSL StyleSheets to transform into the requested formats ( html, csv, ExcelXML, etc. ); Don WHITEPAGES.COM \| INC Everything I've learned in life can be summed up in a small perl script!	[reply] [d/l]
Re^2: PERL AND XML by Anonymous Monk on Jul 30, 2005 at 22:10 UTC
Hi Everyone, I want a spread sheet of data. I did try some xml code of my own but I am not sure ..if this is working.For some reason all the data is coming into 1 cell.... I was the data to appear as `server1 Running 2005-07-24 22:58:06 server2 Running 2005-07-26 13:48:23 server3 Running 2005-07-24 22:51:20` [download] in the spread sheet. I have an immediate deadline...any further help to debug the code will be appreciated. BTW:Don I did try your suggestion with the XML::Element but I think we need some lib' for that which we dont hv in our prod environment. <	[reply] [d/l]
Re^3: PERL AND XML by Anonymous Monk on Jul 30, 2005 at 23:09 UTC
Here is the code I was trying to work on...but it gets created on 1 cell when I try to open it in a excel spread sheet # start an XML worksheet open (my $xmlfl,"+>>$path/$file") or die "$file failed: $!\n" +; print $xmlfl "<?xml version=\"1.0\"?>\n"; print $xmlfl "<Workbook xmlns=\"urn:schemas-microsoft-com:offi +ce:spreadsheet\"\n"; print $xmlfl " xmlns:o=\"urn:schemas-microsoft-com:office:offi +ce\"\n"; print $xmlfl " xmlns:x=\"urn:schemas-microsoft-com:office:exce +l\"\n"; print $xmlfl " xmlns:ss=\"urn:schemas-microsoft-com:office:spr +eadsheet\">\n"; print $xmlfl " <Worksheet ss:Name=\"Policy-Groups\">\n"; print $xmlfl " <Table>\n"; # print $xmlfl the header row # <group> <policy1> <policy2> ... <policyn> print $xmlfl " \n<Row>"; foreach $app(keys %appsrvr) { print $xmlfl " <Cell><Data ss:Type=\"String\">$app< +/Data></Cell>"; print $xmlfl " </Row>"; print $xmlfl " <Row>\n"; foreach $attribute(keys %{ $appsrvr{$app} }) { #print " $appsrvr{$app}{$attribute}"; print $xmlfl " <Row>\n"; print $xmlfl " <Cell><Data ss:Type=\"String\">$appsrvr{$app +}{$attribute}</Data></Cell>\n"; print $xmlfl " </Row>\n"; } # print $xmlfl " </Row>\n" } # print "\n"; # End the XML worksheet print $xmlfl " </Table>\n"; print $xmlfl " </Worksheet>\n"; print $xmlfl "</Workbook>\n"; # close this group file [download] CodeTags™ by holli	[reply] [d/l]
Re^4: PERL AND XML by BaldPenguin (Friar) on Jul 31, 2005 at 03:50 UTC
Re^3: PERL AND XML by BaldPenguin (Friar) on Jul 31, 2005 at 04:03 UTC
HTML::TreeBuilder is required for XML::Element Don WHITEPAGES.COM \| INC Everything I've learned in life can be summed up in a small perl script!	[reply]
Re: PERL AND XML by davidrw (Prior) on Jul 31, 2005 at 19:33 UTC
A lot of good answers above.. i just wanted to mention two side notes: first is that (if it suits your requirements) you can use Win32::OLE to control excel. Second is a quick point to meryln's node "Question" vs "Doubt" in reference to the phrasing of the node ("I have a doubt in using..."). (and by no means making any judgements based on language usage--i just also, as a pretty much english-only monk, find the word switch interesting; onther than that single word i'd have no reason to believe the node wasn't written by a native english speaker)	[reply]

Back to Seekers of Perl Wisdom