How to: Add New Worksheets to Workbooks
Updated: July 2008
The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.
Microsoft Office version
For more information, see Features Available by Application and Project Type.
You can programmatically add a new worksheet to the collection of worksheets in the workbook.
To add a new worksheet to a workbook in a document-level customization
To add a new worksheet to a workbook in an application-level add-in
The new worksheet is a native Worksheet object and not a host item. Starting in Visual Studio 2008 Service Pack 1 (SP1), you can generate a Microsoft.Office.Tools.Excel.Worksheet host item from the native Worksheet object. For more information, see Extending Word Documents and Excel Workbooks in Application-Level Add-ins at Run Time.