GrapeCity.Documents.Excel.IWorksheets.Add

Add Method

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

IWorksheet Add()

Function Add() As IWorksheet

Type	Description
IWorksheet	Returns the new worksheet.

IWorksheets worksheets = workbook.Worksheets;
IWorksheet newSheet = worksheets.Add();
int count = worksheets.Count;

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

IWorksheet Add(SheetType type)

Function Add(type As SheetType) As IWorksheet

Type	Name	Description
SheetType	type	The sheet's type.

Type	Description
IWorksheet	Returns the new sheet.

IWorksheets worksheets = workbook.Worksheets;
IWorksheet chartSheet = worksheets.Add(SheetType.Chart);
SheetType sheetType = chartSheet.Type;