selective import of XML into Excel ?

Discussion in 'Programming' started by Chenks, Oct 9, 2013.

Share This Page

  1. Chenks

    Chenks Registered Trader

    Joined:
    Jan 5, 2002
    Messages:
    3,741
    Likes Received:
    0
    I have an XML file that i want to be to able to import into Excel 2007, however i only want to select some of the data in the XML file to be imported.

    Initially if i could work out how to do this manually, and then come up with some automated process for a bunch of XML files.

    I have a sample XML file here https://www.dropbox.com/s/oa3dop5636245q2/test.xml

    and the only data we need to extract is

    ContractOrderReference
    BuyersOrderNumber
    LineNumber
    SuppliersProductCode
    Description
    Amount
    UnitPrice

    preferably all on one row of the excel file.

    so is this possible? and is this an efficient way of doing it ?