Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

XML Export from Excel

  • 04-05-2010 09: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