Share via


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

  • Document-level projects

  • Application-level projects

Microsoft Office version

  • Excel 2003

  • Excel 2007

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 Object Model Overview

Excel Application-Level Add-in Development

Excel Document-Level Customization Development

Configuring Globalization and Localization