Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
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?
[marto]: hopefully you guys are also well :)
[Corion]: marto: Yeah - I'm looking for a week off in a week, even if it'll be a trip to Amsterdam ;)
[Discipulus]: oh thanks, i'm always at well as the ratchet or bucket
[Corion]: But I'm slowly starting to get into programming again - yesterday I translated my talk for YAPC::E (in Amsterdam) to English, and decided to put my Jekyll-clone to rest for the time being
[Corion]: Discipulus++ # being well is like being earnest
[marto]: hopefully next year I'll be in a position to go to Perly things in Europe :)
[Corion]: Maybe I'll use the Real Jekyll a bit to get a feel for how it actually works, and to get annoyed by it ;)
[Corion]: marto: That would be cool :) There is no kids care at Perly events unfortunately, so it's not entirely family friendly
[Corion]: I think I should define a set of (say) five projects through which I rotate from time to time, just to prevent myself from being bored/annoyed by the problems they get stuck in ;)
[marto]: Corion, not bringing the kids would make it ideal :P

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (8)
As of 2017-07-27 07:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I came, I saw, I ...
























    Results (404 votes). Check out past polls.