Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Excel-Based Samples

Excel-Based Samples

Note Required applications

The features in this topic are available only if you have the required applications installed.

For more information, see Features Available by Product Combination.

  • One of these development environments:

    VSTO 2005


    Visual Studio Team System

  • Microsoft Office 2003

This section contains sample applications that illustrate how to use managed code extensions in creating business solutions that take advantage of the data collection and analysis capabilities available in Microsoft Office Excel 2003.

In This Section

Data Analysis Sample

Demonstrates an inventory management application that executes data analysis tasks in Excel using menus, toolbar buttons, and a pivot table.

Excel Controls Sample

Demonstrates how to use managed code extensions to access controls that are hosted on an Excel worksheet.

Excel Dynamic Controls Sample

Demonstrates how to add and remove Windows Forms controls and host controls programmatically.

Master Detail Data Sample

Demonstrates how to retrieve data from a relational database or XML file and use that data in Excel.

Excel Document Protection Techniques Sample

Demonstrates various techniques you can use to protect structural components of a worksheet to help to prevent users from accidentally deleting controls or otherwise changing important parts of your solution document.

Excel Smart Tags Sample

Demonstrates how you can incorporate smart tags into your Excel solution.

Related Sections

Office Development Samples

Provides links to sample applications that take advantage of Microsoft Office Word 2003 and Excel.

Word-Based Samples

Provides links to sample applications that use Word to solve common business problems.

Samples That Use Excel and Word

Provides links to sample applications that show how to use features that can be implemented in both Excel and Word, such as the actions pane and data access.

Office Development Walkthroughs

Lists step-by-step guides that provide an introduction to Microsoft Visual Studio 2005 Tools for the Microsoft Office System and help to illustrate how you can create applications that take advantage of Word and Excel.

Community Additions

© 2015 Microsoft