Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: Using Perl to go from XML to EXCEL

by dHarry (Abbot)
on Mar 18, 2011 at 11:08 UTC ( #893974=note: print w/replies, xml ) Need Help??


in reply to Using Perl to go from XML to EXCEL

Although you are looking for a Perl solution (as a non-Perl programmer?) I will mention two alternative solutions.

1. Depending on the version of Excel that you are using you can also directly import XML into Excel. The web is full of examples.

2. You can solve it using a more XML-ish way. In general, whenever you have to transform XML into something think XSLT. The simplest way of producing something that can be imported in Excel is to produce CSV. See for example Using XML::XSLT to convert XML to CSV for some ideas.

Cheers

Harry

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://893974]
help
Chatterbox?
[chacham]: it is a nice ide. its just that upgrading it always causes issues with mismatched versions of whatever
[Corion]: chacham: Oh, yes, reinstalling all the SDK versions and Gradle and whatnot, yes, even in the short time I used it (2 weeks?) I felt that pain
[chacham]: right now im editing the versions in the applications gradle file to use a version it wants. sheesh.
[Corion]: Ow, "but you're not supposed to do that" ;)
[chacham]: with google, you kinda just gotta do what it recomends.

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (10)
As of 2017-03-29 08:04 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should Pluto Get Its Planethood Back?



    Results (344 votes). Check out past polls.