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 4 of 4
  1. #1
    New Coder
    Join Date
    Apr 2007
    Posts
    59
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Converting excel data into simple xml format?

    Hi,

    I am building an image gallery that sources its images and thumbnails and titles etc from an xml file.

    For keeping the data in an easily manageable format, and because we are many who will update the gallery and not everyone will be comfortable with editing an XML-file, I think it would be great to have the data in an Excel spreadsheet, with a column for the fullsized image name, another for the thumbnail and a third for the title, and so on.

    But how could I get that data into an xml-formatted file that my image gallery would understand?

    I tried saving in Excel as XML but it saved a very complex spreadsheet thing.

    Look at the screenshot below, I want to just go from the top image to the bottom image. Does anyone know how I could achieve this? I guess a custom macro in Word could do it but I'd prefer to just export from Excel (I am thinking it has to be possible!).




    Thanks a lot for any ideas!

    /g

  • #2
    New to the CF scene
    Join Date
    Dec 2008
    Posts
    9
    Thanks
    2
    Thanked 0 Times in 0 Posts
    You can create some PHP script to convert Excel to XML.
    I am not sure how to create but POST "Script to convert XLS to XML" on various forums. You will get readymade script.

  • #3
    New Coder
    Join Date
    Apr 2007
    Posts
    59
    Thanks
    10
    Thanked 0 Times in 0 Posts
    Thanks for replying.

    Sorry, I was not entirely clear. I am not looking to convert online/on the fly/in real time. I am looking for a pre-publishing solution. A bit like when we create an image in Photoshop and then optimize for the web and only upload the optimized image.

    I guess I am actually asking how to export from Excel to my desired output format, but rather than posting in an Excel forum, I figured I would ask here since I presumed that many people would keep their data in speadsheets, and then convert that data to XML before putting it online, and thus would know exactly how to achieve my desired outcome.

  • #4
    Master Coder
    Join Date
    Dec 2007
    Posts
    6,682
    Thanks
    436
    Thanked 890 Times in 879 Posts
    Quote Originally Posted by guermantes View Post
    Thanks for replying.

    Sorry, I was not entirely clear. I am not looking to convert online/on the fly/in real time. I am looking for a pre-publishing solution. A bit like when we create an image in Photoshop and then optimize for the web and only upload the optimized image.

    I guess I am actually asking how to export from Excel to my desired output format, but rather than posting in an Excel forum, I figured I would ask here since I presumed that many people would keep their data in speadsheets, and then convert that data to XML before putting it online, and thus would know exactly how to achieve my desired outcome.
    - post a sample with your excell converted to xml
    - post another sample with xml for your output
    - decide with what xslt processor want to use

    to automate all this, see this link:

    http://www.vex.net/~cthuang/tcom/

    if you think that tcl/tk is not what you want, look for a vb or other way to do this.

    regards


  •  

    Posting Permissions

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