GrapeCity.Documents.Excel.IWorksheets.MoveAfter

MoveAfter Method

MoveAfter(IWorksheet)

Moves the sheet collection to the location after the specified sheet.

Declaration

IWorksheets MoveAfter(IWorksheet targetSheet)

Function MoveAfter(targetSheet As IWorksheet) As IWorksheets

Parameters

Type	Name	Description
IWorksheet	targetSheet	The sheet after which the moved sheet collection will be placed. It can be the sheet of the same or another workbook.

Returns

Type	Description
IWorksheets	The moved sheet collection.

Examples

workbook.Worksheets.Add().Name = "Summary";
IWorksheets sheets = workbook.Worksheets[new string[] { "Sheet1", "Summary" }];
IWorksheet targetSheet = workbook.Worksheets.Add();
IWorksheets movedSheets = sheets.MoveAfter(targetSheet);