Programmatically create new workbooks

When you create a workbook programmatically, it is a native Workbook object, not a Workbook host item.

Applies to: The information in this topic applies to document-level projects and VSTO Add-in projects for Excel. For more information, see Features available by Office application and project type.

You can generate a Workbook host item for a Workbook object in VSTO Add-in project. For more information, see Extend Word documents and Excel workbooks in VSTO Add-ins at run time.

To create a new workbook

Documentation

Programmatically add new worksheets to workbooks

Create a Microsoft Office Excel worksheet and add the worksheet to the collection of worksheets in the workbook programmatically from Visual Basic or C#.
Programmatically open workbooks - Visual Studio (Windows)

Open or work with an existing Microsoft Office Excel workbook programmatically from Visual Basic or C# in Visual Studio.
Programmatically save workbooks - Visual Studio (Windows)

Save Microsoft Excel workbooks without changing the path and save a copy without modifying the open workbook in memory programmatically in Visual Studio.
Programmatically list all worksheets in a workbook

Learn how you can programmatically list all worksheets in a Microsoft Excel workbook by using Visual Studio.
Programmatically close workbooks - Visual Studio (Windows)

Close the active Microsoft Office Excel workbook or specify a workbook to close programmatically from Visual Basic or C#.
Programmatically select worksheets - Visual Studio (Windows)

Select Microsoft Excel worksheets with the worksheet host item or sheets collection of the Excel workbook programmatically from Visual Basic or C# in Visual Studio.

Training

Module

This module walks through development of Office Add-ins for Microsoft Excel.

Certification

Demonstrate that you have the skills needed to get the most out of Excel 2016 by earning a Microsoft Office Specialist (MOS) certification.