How to Bind Data in VSTO

Visual Studio Tools for Office (VSTO) is an Integrated Development Environment (IDE) used to develop console and graphical user interface (GUI) applications. You can also use it to create Windows forms applications, web applications, web services and web sites. VSTO has a GUI wizard that allows you to to create custom controls and applications without XML configuration. You can also bind data, connecting data to a source, through a VSTO script.

Instructions

1. Launch Microsoft Excel. Press "Alt" and "F11" to launch VSTO.

2. Click "Module."

3. Select a "Webservice" from the menu displayed that links to your data set.

4. Click "Data Sources" and double-click the data set from your web service to bind.

5. Drag and drop the data set onto the worksheet as a ListObject. Type the following code and press "Enter":

   dsExcel datasetInstance = GetDataSetFromWebService(); // replace with the call to your web service

   this.vw_DataBindingSource.DataSource = datasetInstance.vw_Data

Resources

• MSDN: VSTO