How to: Add XMLMappedRange Controls to Worksheets

Applies to

The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.

Project type

  • Document-level projects

Microsoft Office version

  • Excel 2007

  • Excel 2003

For more information, see Features Available by Application and Project Type.

When you map an XML element to a cell in Microsoft Office Excel, Visual Studio Tools for Office 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. Open the XML Source task pane:

    • For Excel 2003 projects, on the Data menu, point to Microsoft Office Excel Data, point to XML, and then click XML Source.


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

    • For Excel 2007 projects, on the Developer tab, click Source.


    If the Developer tab is not visible on the Ribbon, you must enable it. For more information, see How to: Show the Developer Tab on the Ribbon.

    The XML Source task pane appears.

  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


How to: Map Schemas to Worksheets Inside Visual Studio


XmlMappedRange Control

Host Items and Host Controls Overview

Programmatic Limitations of Host Items and Host Controls

Other Resources

Excel Host Controls

Word Host Controls