GrapeCity.Documents.Excel.IWorksheets.MoveBefore

MoveBefore Method

MoveBefore(IWorksheet)

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

Declaration

IWorksheets MoveBefore(IWorksheet targetSheet)

Function MoveBefore(targetSheet As IWorksheet) As IWorksheets

Parameters

Type	Name	Description
IWorksheet	targetSheet	The sheet before 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.MoveBefore(targetSheet);