How to: Add XMLMappedRange Controls to Worksheets
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

How to: Add XMLMappedRange Controls to Worksheets

Note Required applications

The features in this topic are available only if you have the required applications installed.

For more information, see Features Available by Product Combination.

  • One of these development environments:

    VSTO 2005


    Visual Studio Team System

  • Microsoft Office 2003

When you map an XML element to a cell in Microsoft Office Excel 2003, Microsoft Visual Studio 2005 Tools for the Microsoft Office System automatically adds an XMLMappedRange control to your worksheet.


The XMLMappedRange control is not available on the Toolbox or the Data Sources window. Additionally, you cannot create XMLMappedRange controls programmatically.

To add an XMLMappedRange control to a worksheet

  1. From the Data menu, point to Microsoft Office Excel Data Commands, point to XML and select XML Source.

    The XML Source task pane appears.


    If Microsoft Office Excel Data Commands is not available in the Data menu, click the document to give it focus.

  2. In the XML Source task pane, click XML Maps.

  3. In the XML Maps dialog box, click Add.

    The XML Source dialog box appears.

  4. Select an XML schema from the XML Source dialog box and click Open.

    The schema is added to the XML Maps dialog box.

  5. In the XML Maps dialog box, click OK.

  6. Drag an element from the XML Source task pane to a cell on the worksheet.

    An XMLMappedRange is created and added to the project.


    If you drag a parent element from the XML Source task pane, a ListObject control is created.

See Also

© 2016 Microsoft