Visual Studio 2010 and Visual Studio 2008 provide project templates you can use to create application-level add-ins for Excel. You can use add-ins to automate Excel, extend Excel features, or customize the Excel user interface.
Getting started
Topic
Description
Install Office developer tools, including the Visual Studio Tools for Office runtime and project templates and designers.
Explore topics that help you use the Office developer tools in Visual Studio 2010.
Find answers to common questions about programming Office solutions.
Use developer tools designed to complement Visual Studio Tools for Office.
Create an application-level add-in for Excel.
Walkthrough on how to create document-level customizations.
Interact with the objects that are provided by the Excel object model.
Working with workbooks
Topic
Description
Methods and properties to perform tasks with workbooks.
A workbook object that exposes events and acts as a container for components.
How to set document properties in Excel and Word.
Read and modify custom document properties that are stored with documents.
Contains the methods and properties used to perform tasks with Excel workbooks.
Contains a set of types that extend and support the Microsoft Office Excel object model.
Working with worksheets
Topic
Description
Contain methods and properties you use to perform tasks with worksheets.
Extends the Microsoft.Office.Interop.Excel.Worksheet type from the primary interop assembly for Excel
Represents a worksheet in Excel projects created by using the Office development tools in Visual Studio.
Contains a set of types that extend and support the Microsoft Office Excel object model.
Working with ranges
Topic
Description
Write code that interacts with ranges in a variety of ways in Excel.
Contains the methods and properties used with Excel ranges and classes.
Extend and support the Excel object model by using Office development tools.
Working with charts
Topic
Description
Add a chart to a worksheet without traversing the Excel object model.
Automatically create a ChartSheet host item at design time using Visual Studio.
Add Chart controls to an Excel worksheet at design time and at run time.
Use shapes to gain flexibility for creating bubble charts in Excel.
A set of types that extends and supports the Microsoft Office Excel object model.
Working with cells
Topic
Description
Contains methods and properties to perform tasks with cells.
Extends and supports Excel object model by using the Office development tools.
A set of types that extends and supports the Microsoft Office Excel object model.
Working with data
Topic
Description
Bind data to controls in both application-level and document-level projects.
Add controls to enable scrolling through all the records in a table.
Access data in document-level Visual Studio Tools for Office projects in the same way as accessing data in Windows Forms projects.
Use the designer to display a single field from a database table in an Excel worksheet, with controls that enable the user to scroll through all the records.
Walkthrough demonstrates the basics of complex data binding in a document-level project.
Bind data to host controls and Windows Forms controls in application-level projects.
Bind a host control to a data source and update the data source with the changes that are made to the data in the control.
In this step-by-step tutorial learn how to take data offline and use it to generate reports in Excel.
Bring bug data from Team Foundation Server into Excel and Word using VSTO for analysis
A simple Office Business Application used by the new Northwind Traders.
Data binding to controls on an actions pane demonstrating a master/detail relation between tables in a SQL Server database.
Maintain a local database in situations where maintaining a centralized database is not required.
Cache data objects in a document-level customization so that the data can be accessed offline.
Access data that is contained in a document on a server that does not have Word or Excel installed.
Customizing the UI
Topic
Description
Use WPF controls as an alternative to Windows Forms for designing user interfaces.
Using the Word and Excel command bar in Visual Studio Tools for Office.
Topic
Description
Learn to customize the Ribbon using the Ribbon (Visual Designer) item or the Ribbon (XML) item.
Display the Developer tab on the Ribbon.
Customize the Ribbon by adding a Ribbon (Visual Designer) or Ribbon (XML) item to an Office project.
Create a custom Ribbon tab by using the Ribbon Designer.
Set the width of a drop down control by using the Ribbon Designer.
Change the order of tabs on a Ribbon by using the Tab Collection Editor.
Add groups and controls to a tab that is already on the Ribbon.
Design a Ribbon by using the Ribbon visual designer then re-use that same Ribbon in more than one Office application.
Use the Ribbon (XML) item to customize the Ribbon in a way not supported by the Ribbon (Visual Designer) item.
Working with custom task panes
Topic
Description
Create a Windows Forms user control to add an actions pane to a workbook.
Add a custom task pane by using an application-level add-in.
Use data binding to controls on an actions pane to demonstrate a master/detail relation between tables in a SQL Server database.
Write code to stack the user controls on the actions pane.
Create a custom task pane that users can hide or display by clicking a toggle button on the Ribbon.
Topic
Description
Enable Smart tags in Word or Excel on the end user computer.
Add smart tags to Excel by using a document-level customization or an application-level add-in.
Working with XML
Topic
Description
Map an XML schema to a worksheet in Visual Studio while a worksheet is open.
Create a custom XML part in a document-level customization to store XML data.
Store XML data by creating a custom XML part in an application-level add-in.
Using Open XML
Topic
Description
Explore the architecture the Open XML Format SDK 2.0 and see scenarios on how to assemble and manipulate data using Open XML.
Use the Open XML Formats to load information stored in Excel worksheets into generic lists that support LINQ.
Add information to a specific cell in an Excel 2007 workbook or set of workbooks.
Retrieve cell values from worksheets in Excel 2007 programmatically.
Learn how to retrieve lists of worksheets from Excel programmatically.
Add a custom XML part to a document without starting Office.
