Excel Solutions
Applies to |
|---|
The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office. Project type
Microsoft Office version
For more information, see Features Available by Application and Project Type. |
Visual Studio Tools for Office provides project templates you can use to create document-level customizations and application-level add-ins for Microsoft Office Excel. You can use these solutions to automate Excel, extend Excel features, and customize the Excel user interface (UI).
For more information about document-level customizations, see Excel Document-Level Customization Development. For more information about application-level add-ins, see Getting Started Programming Application-Level Add-Ins.
Creating an Excel Project
Create the following types of Excel projects by using the project templates in the New Project dialog box:
Excel add-in
Excel workbook
Excel template
This template includes required assembly references and project files. Visual Studio Tools for Office provides a version of these templates for Microsoft Office 2003 and the 2007 Microsoft Office system.
For more information about how to create an Excel project, see How to: Create Visual Studio Tools for Office Projects. For more information about the project templates, see Visual Studio Tools for Office Project Templates Overview.
Automating Excel by Using the Excel Object Model
The Excel object model exposes many types that you can use to automate Excel. For example, you can programmatically create worksheets, and set the values of ranges and cells. For more information, see Excel Object Model Overview.
See Also
Concepts
Excel Application-Level Add-in Development