GrapeCity.Documents.Excel.IWorksheets.AddBefore

AddBefore Method

AddBefore(IWorksheet)

Creates a new worksheet and inserts it before the specified sheet.

Declaration

IWorksheet AddBefore(IWorksheet sheet)

Function AddBefore(sheet As IWorksheet) As IWorksheet

Parameters

Type	Name	Description
IWorksheet	sheet	The specified sheet index.

Returns

Type	Description
IWorksheet	Returns the new worksheet.

Examples

IWorksheets worksheets = workbook.Worksheets;
worksheet.Name = "Summary";
IWorksheet detailSheet = worksheets.AddBefore(worksheet);
detailSheet.Name = "Detail";
int index = detailSheet.Index;