Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.
Hi all, please see this major site announcement: https://www.boards.ie/discussion/2058427594/boards-ie-2026

XML Export from Excel

  • 04-05-2010 08:11AM
    #1
    dave13
    Registered Users, Registered Users 2 Posts: 815 ✭✭✭


    Hi
    Been landed with doing some xml conversion work.
    basically there is data in a sample excel worksheet and we've been given xml schemas for conversion. I've added the xml schemas as mind maps in excel but i'm a bit out of my depth with mappings.
    I've been reading around but cant find a guide for this situation.
    Anyone have any pointers?
    Thanks.
    Tagged:


Comments

  • #2
    Dr.Silly
    Closed Accounts Posts: 1,759 ✭✭✭Dr.Silly


    Ares wrote: »
    Hi
    Been landed with doing some xml conversion work.
    basically there is data in a sample excel worksheet and we've been given xml schemas for conversion. I've added the xml schemas as mind maps in excel but i'm a bit out of my depth with mappings.
    I've been reading around but cant find a guide for this situation.
    Anyone have any pointers?
    Thanks.

    have you tried this

    http://www.microsoft.com/downloads/details.aspx?FamilyId=72852247-6AFD-425C-83B1-1F94E4AC2775&displaylang=en


  • #3
    dave13
    Registered Users, Registered Users 2 Posts: 815 ✭✭✭dave13


    Cheers, gave it a go but its just extra excel functions.
    Been given a sample excel workbook, the schema and the expected output but just cant get it to map as the xsd just specifies repeating elements for a table(ie 7 columns x 38 rows) and whenever i try to map it it jsus maps a couple of cells. Doing something wrong but cant find any examples similar to this.


Advertisement