Excel-Based Samples

  • Article

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.

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.

  • Document-Level Samples
    Provides links to sample applications that take advantage of Microsoft Office Word 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.