How to: Map Schemas to Worksheets Inside Visual Studio
You can map an XML schema to a worksheet while the worksheet is open in Visual Studio. You use the same Microsoft Office Excel tools that you use when the workbook is open outside of Visual Studio. The Office project creates the same objects whether you map the schema to the worksheet before or after you create your Excel solution.
Applies to: The information in this topic applies to document-level projects for Excel 2013 and Excel 2010. For more information, see Features Available by Office Application and Project Type.
You cannot use multipart XML schemas in Excel solutions.
To map an XML schema to an Excel worksheet in Visual Studio
Open the Excel workbook or template project inside Visual Studio.
Click in the worksheet to move the focus to the designer.
On the Ribbon, click the Developer tab.
If the Developer tab is not visible, you must first show it. For more information, see How to: Show the Developer Tab on the Ribbon.
In the XML group, click Source.
The XML Source window opens.
In the XML Source window, click XML Maps.
The XML Maps dialog box opens.
In the XML Maps dialog box, click Add.
Browse to your schema file, select it, and then click Open.
Drag elements from the XML Source window to the places in your worksheet where you want the corresponding controls to be created.
If you drag a repeating schema element, the Office project generates a ListObject control that is not automatically bound to a data source. For more information, see XML Schemas and Data in Document-Level Customizations.