Updated: July 2008
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.
You can programmatically add a new worksheet to the collection of worksheets in the workbook.
Use the Add method of the Sheets collection.
Dim newWorksheet As Excel.Worksheet newWorksheet = CType(Globals.ThisWorkbook.Worksheets.Add(), Excel.Worksheet)
Excel.Worksheet newWorksheet; newWorksheet = (Excel.Worksheet)Globals.ThisWorkbook.Worksheets.Add( missing, missing, missing, missing);
The new worksheet is a native Microsoft.Office.Interop.Excel..::.Worksheet object and not a host item. If you want to add a Microsoft.Office.Tools.Excel..::.Worksheet host item, you should add the worksheet at design time.
Dim newWorksheet As Excel.Worksheet newWorksheet = CType(Me.Application.Worksheets.Add(), Excel.Worksheet)
Excel.Worksheet newWorksheet; newWorksheet = (Excel.Worksheet)this.Application.Worksheets.Add( missing, missing, missing, missing);
The new worksheet is a native Microsoft.Office.Interop.Excel..::.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 Microsoft.Office.Interop.Excel..::.Worksheet object. For more information, see Extending Word Documents and Excel Workbooks in Application-Level Add-ins at Run Time.
Date
History
Reason
July 2008
Added a code example that can be used in an application-level add-in.
Customer feedback.