The Daily Static
  The Daily Static
UF Archives
Register
UF Membership
Ad Free Site
Postcards
Community
Geekfinder
UFie Gear
Advertise on UF
Forum Rules
& FAQ

Username

Password


Create a New Account

  
 

Back to UserFriendly Strip Comments Index
Convert XML files into Excel spreadsheet? by ag_wyvern 2006-03-31 09:46:25
I have several .xml files all containing the 'same' information in different languages.

I need to generate an Excel spreadsheet with one row for each tag, each row containing 6 cells (one for each language), where the cells contain the string corresponding to the tag.

In other words:
---tag---    --Eng-- --Fr-- ....etc...
<tag_name1>  Yes     Oui
<tag_name2>  No      Non
<tag_name3>  Hello   Bonjour
...etc...

Does anyone know of a *quick* way to do this? I need to get it out today.

Thanks.
[ Reply ]
  VBA module using the XML parser? (n/t) by merlin2006-03-31 10:45:49
    What do you mean? by ag_wyvern2006-03-31 11:08:42
      Excel allows you to write custom code using by merlin2006-11-19 12:55:59
  Just hack it by Didactylos2006-03-31 11:40:45
    Hack *which*? by ag_wyvern2006-03-31 11:51:30
      Did you check out my link? by merlin2006-11-19 12:55:59
        Trying to follow it. by ag_wyvern2006-03-31 12:17:02
          Another link for you in your new TLP, btw (n/t) by merlin2006-03-31 12:37:46

 

[Todays Cartoon Discussion] [News Index]

Come get yer ARS (Account Registration System) Source Code here!
All images, characters, content and text are copyrighted and trademarks of J.D. Frazer except where other ownership applies. Don't do bad things, we have lawyers.
UserFriendly.Org and its operators are not liable for comments or content posted by its visitors, and will cheerfully assist the lawful authorities in hunting down script-kiddies, spammers and other net scum. And if you're really bad, we'll call your mom. (We're not kidding, we've done it before.)