Working with Workbooks

Working with Workbooks

 

The Workbook and Workbooks class contains the methods and properties you use to perform tasks with workbooks.

TaskProcedure
Create a new workbook.How to: Programmatically Create New Workbooks
Open a specified workbook.How to: Programmatically Open Workbooks
Close a specified workbook and save changes.How to: Programmatically Close Workbooks
Save workbooks in Excel formats or XML format.How to: Programmatically Save Workbooks
Bring the focus to the current workbook or a different workbook.
How to: Programmatically Protect Workbooks
Get a collection of recently used workbook files.How to: Programmatically List Recently Used Workbook Files
Open text files as workbooks.How to: Programmatically Open Text Files as Workbooks

For more information about Excel tasks and the Excel object model, see Excel Object Model Overview.

In some cases, the ways that you perform these tasks in VSTO Add-ins is different from the ways that you perform them in document-level customizations.

Automating Excel by Using Extended Objects
Working with Worksheets
Working with Ranges
Using Windows Forms Controls on Excel Worksheets

Show:
© 2016 Microsoft