Importing XMl into Excel using a XSD map

Posted on 2007-10-21
Last Modified: 2008-01-09
I am importing XML files into an Excel spreadsheet.  I open the XML source pane and open an XML map. I drag the folder in the source pane over to the cell where I want the data to begin and the cells are circled in blue.  I then import data into those cells.  I then delete the XML map and close the file.  My question is: do I need to delete the map each time or is there an easier way of doing this?
Question by:Dier02
    LVL 10

    Expert Comment

    Maybe help
    Importing XML Maps, XML Lists, and Dynamic Chart Sources in Excel 2003

    wbr Janos

    Author Comment

    So if I hyad an existing spreadsheet and an existing schema or map and my map was called BSC how would I attach a button to my task bar in Excel 2003 and then attach the code to import XML data according to this BSC map?
    LVL 10

    Expert Comment

    How to create a taskbar:
    RightClick Menu / Customize
    New  -> New Toolbar  Toolbar Name: MyToolbar  OK

    Select Commands tab   Macros  and drag  CustomButton onto MyToolbar
    Right click Custom Button: you can rename and change button image
    Close Customize
    Click CustomButton on MyToolbar -> Assign Macro and you can select the needed macro to this button


    Author Comment

    how would I create a macro that applied the map then imported the data?
    LVL 10

    Accepted Solution

    Add XML Functionality in Microsoft Office Excel 2003 from Microsoft Visual Basic .NET

    I hope this help you

    wbr Janos

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Training Course: Java/J2EE and SOA

    This course will cover both core and advanced Java concepts like Database connectivity, Threads, Exception Handling, Collections, JSP, Servlets, XMLHandling, and more. You'll also learn various Java frameworks like Hibernate and Spring.

    Suggested Solutions

    Title # Comments Views Activity
    Unable to resolve XML http request 4 37
    Problem to event 3 26
    Complex Lookup Formulas 3 30
    Excel list clean up 6 19
    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    This script will sweep a range of IP addresses (class c only, and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now