Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6

Thread: XML and excel

  1. #1
    Regular Coder
    Join Date
    Jun 2002
    Location
    Northern NJ
    Posts
    404
    Thanks
    0
    Thanked 1 Time in 1 Post

    XML and excel

    Has anyone used XML/XSL to grab info out of an excel worksheet and display it on a web page? I want to grab say information ( the GDP of peru ) and output that on a page if peru is selected. The excel document exist in the same directory. Can anyone help? All help is appreciated, thanks.
    I would rather be a lion for a day than a lamb that lives forever.

  • #2
    Senior Coder
    Join Date
    Jun 2002
    Location
    near Oswestry
    Posts
    4,508
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Er ... if your data is in an Excel spreadsheet, where does XML come into it?

    XSL cannot process documents which are not XML. I'd say, ditch the spreadsheet and keep its data in XML; from that basis, XSL-based data mining is simple.
    "Why bother with accessibility? ... Because deep down you know that the web is attractive to people who aren't exactly like you." - Joe Clark

  • #3
    jkd
    jkd is offline
    Senior Coder jkd's Avatar
    Join Date
    May 2002
    Location
    metro DC
    Posts
    3,163
    Thanks
    1
    Thanked 18 Times in 18 Posts
    brothercake, Office XP can save documents in an XML format, including Excel spreadsheets.

    I've never used XSLT directly on such an XML document, the markup that is produced is so bulky and extraneous that it. However, I've used DOM and Java to get the info I want, store that in a temporary XML document, then use XSLT on that...

  • #4
    Senior Coder
    Join Date
    Jun 2002
    Location
    near Oswestry
    Posts
    4,508
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Oh I see
    "Why bother with accessibility? ... Because deep down you know that the web is attractive to people who aren't exactly like you." - Joe Clark

  • #5
    Regular Coder
    Join Date
    Jun 2002
    Location
    Northern NJ
    Posts
    404
    Thanks
    0
    Thanked 1 Time in 1 Post
    jkd could I use a server side language to do as you stated above? I want to use ASP, can this be done?

    Thanks for all the help thus far.
    I would rather be a lion for a day than a lamb that lives forever.

  • #6
    jkd
    jkd is offline
    Senior Coder jkd's Avatar
    Join Date
    May 2002
    Location
    metro DC
    Posts
    3,163
    Thanks
    1
    Thanked 18 Times in 18 Posts
    Well, you can in theory do the entire thing straight out with XSLT, but the XPath expressions required can get nasty.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •