Creates a new worksheet. The new worksheet becomes the active sheet.

Overload List

Creates a new worksheet. The new worksheet will be added after the last worksheet.

[Visual Basic] Function Add() As IWorksheet

[C#] IWorksheet Add();

[C++] IWorksheet* Add();

[JScript] function Add(): IWorksheet;

Creates a new worksheet. You can insert the new worksheet either before or after an existing worksheet.

[Visual Basic] Function Add(ByVal Object,ByVal Object) As IWorksheet

[C#] IWorksheet Add(object,object);

[C++] IWorksheet* Add(Object*,Object*);

[JScript] function Add(Object,Object): IWorksheet;

Creates new worksheets. You can insert the new worksheets either before or after an existing worksheet.

[Visual Basic] Function Add(ByVal Object,ByVal Object,ByVal Integer) As IWorksheet

[C#] IWorksheet Add(object,object,int);

[C++] IWorksheet* Add(Object*,Object*,int);

[JScript] function Add(Object,Object,int): IWorksheet;

Example

This example creates a new worksheet after last worksheet.

[C#]
book.Worksheets.Add();

[Visual Basic]
book.Worksheets.Add()

[C++]
book->Worksheets->Add();

This example creates a new worksheet after sheet with name "Orders".

[C#]
book.Worksheets.Add(null, "Orders");

[Visual Basic]
book.Worksheets.Add(Nothing, "Orders")

[C++]
book->Worksheets->Add(null, S"Orders");

This example creates a new worksheet before worksheet with index 2.

[C#]
book.Worksheets.Add(2, null);

[Visual Basic]
book.Worksheets.Add(2, Nothing)

[C++]
book->Worksheets->Add(2, null);

See Also

IWorksheets Interface | NativeExcel Namespace

---