GrapeCity.Documents.Excel.IWorksheets.AddAfter

AddAfter Method

AddAfter(IWorksheet)

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

Declaration

IWorksheet AddAfter(IWorksheet sheet)

Function AddAfter(sheet As IWorksheet) As IWorksheet

Parameters

Type	Name	Description
IWorksheet	sheet	The insert sheet.

Returns

Type	Description
IWorksheet	Returns the new worksheet.

Examples

IWorksheets worksheets = workbook.Worksheets;
worksheet.Name = "Data";
IWorksheet summarySheet = worksheets.AddAfter(worksheet);
summarySheet.Name = "Summary";
int index = summarySheet.Index;