GrapeCity.Documents.Excel.IWorksheet.MoveBefore

MoveBefore Method

MoveBefore(IWorksheet)

Moves the sheet to the location before the specified sheet.

The target sheet can belong to the same workbook or a different workbook.

Declaration

IWorksheet MoveBefore(IWorksheet targetSheet)

Function MoveBefore(targetSheet As IWorksheet) As IWorksheet

Parameters

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

Returns

Type	Description
IWorksheet	The moved sheet.

Examples

worksheet.Name = "Data";
IWorksheet summarySheet = workbook.Worksheets.Add();
summarySheet.Name = "Summary";
IWorksheet movedSheet = summarySheet.MoveBefore(worksheet);