Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Aug 2003
    Location
    Lake Forest, Illinois, USA
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    XML Files (Excel 2003)

    Hello! I received an XML document that I typically open in excel and would like to have it open with the headers in a different format (please see attached). Right now, when I open the document, the order starts with address, then cell phone, then CFO region, etc. I would like for it to open in a more logical order (i.e., First name, MI, Last Name, Address, etc). Is there a way for me to do this? Your help is really appreciated! :-)
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: XML Files (Excel 2003)

    Hi dory

    There is no XML map attached to this Excel file so for this to work you have to add an XML map to the workbook

    1) On the Data menu, click XML
    2) Click XML Source
    3) On the XML Source pane
    i) Click XML Maps
    ii) Click Add
    4) Select your XML file
    5) Click Open
    6) Click OK to add the XML map


    You must then map cells to elements in the XML map by simply highlighting the cell or range of cells and dragging the element from the map to your selection of cells.
    Jerry

Posting Permissions

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