The following walkthroughs demonstrate ways you can use document-level customizations and VSTO Add-ins to automate Microsoft Office Excel and customize the user interface (UI).
Demonstrates how to create a basic document-level customization for Excel.
Demonstrates how to add a custom tab to the Ribbon of an Excel workbook.
Illustrates using a Windows Form to collect user input and then sending the input to a cell in an Excel worksheet.
Demonstrates the basics of using check boxes on an Excel worksheet to change formatting.
Demonstrates the basics of using buttons and text boxes on Excel worksheets.
Provides step-by-step instructions on how to add a NamedRange control to a worksheet and program against its events.
Demonstrates the basics of binding a single data field in a SQL Server database to a named range in Excel.
Demonstrates the basics of binding multiple cells in an Excel worksheet to fields in the Northwind SQL Server database.
Demonstrates creating a master/detail relation on a worksheet, and caching the data so that the solution can be used offline.
Shows the basics of changing chart styles using radio buttons on an Excel worksheet.
Describes how to add controls that are bound to a data source to an actions pane in Excel.
Demonstrates how to create a basic VSTO Add-in for Excel.
Demonstrates how to add controls to a worksheet by using a VSTO Add-in.
Demonstrates how to expose an object in a VSTO Add-in to VBA code in a workbook.
Demonstrates how to create a custom task pane that users can hide or display by clicking a toggle button on the Ribbon.
Demonstrates how to bind a table in a SQL Server database to a ListObject in a VSTO Add-in for Excel.