locked
Convert xml file to html or Excel RRS feed

  • Question

  • Hi I have some content in my xml file. I would like to know is it possible to convert that data in xml file into excel file format and also to html file format. Is it possible in vbscript. Any idea??  Below is the sample xml file content looks like,

      <? xml version="1.0" encoding="UTF-8" standalone="yes" ?>
      <? xml-stylesheet type="text/xsl" ?>
    - < DOCUMENT >
      < DocumentName > value </ DocumentName >
      < name > data </ name >
      </ DOCUMENT >
    Monday, June 7, 2010 10:49 AM

Answers

All replies

  • Its been a few years since I've played around with XML and vbs,  I used to use xmldom to access the xml. 

    There's a Good article here on XML Dom http://msdn.microsoft.com/en-us/library/aa468547.aspx

    Is using powershell an option ? 


    Shane Hoey psugbne.org | Powershell Usergroup Brisbane
    • Marked as answer by IamMred Tuesday, August 17, 2010 4:30 PM
    Tuesday, June 8, 2010 6:27 AM
  • Hi thanks for your reply. Can i know how to convert xml to pdf uisng vbscript?? Is that possible???
    Tuesday, June 8, 2010 6:29 AM
  • I've never attempted it,  maybe,   I doubt you could do it natively,  so maybe look for a 3rd party program you can call from your script.

    I'd also be keen to find out if anyone has a way to convert the output into .pdf


    Shane Hoey psugbne.org | Powershell Usergroup Brisbane
    Tuesday, June 8, 2010 6:38 AM
  • Can you able to help me out. Is that possible?????
    Tuesday, June 8, 2010 6:42 AM
  • I would use some kind of pdf printer ( http://www.google.com/search?q=pdf+printer )
    and depending on what output you want, you would need to parse the xml file.
    • Proposed as answer by Oliver Lipkau Sunday, August 15, 2010 5:09 PM
    • Marked as answer by IamMred Tuesday, August 17, 2010 4:30 PM
    Sunday, August 15, 2010 5:09 PM