CreateWorksheet Method

In This Topic

Creates a new Worksheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Function CreateWorksheet( _
   Optional ByVal worksheetName As String, _
   Optional ByVal sheetType As WorksheetType, _
   Optional ByVal insertAt As Integer _
) As Worksheet

'Usage
 
Dim instance As Workbook
Dim worksheetName As String
Dim sheetType As WorksheetType
Dim insertAt As Integer
Dim value As Worksheet
 
value = instance.CreateWorksheet(worksheetName, sheetType, insertAt)

public Worksheet CreateWorksheet( 
   string worksheetName,
   WorksheetType sheetType,
   int insertAt
)

Parameters

worksheetName: A string value indicates the name of the Worksheet.
sheetType: A WorksheetType value indicates the type of the Worksheet.
insertAt: An integer value indicates the position of the new created Worksheet.

Return Value

A Worksheet value represents the new created Worksheet.

Reference

Workbook Class
Workbook Members