Sheet.MoveBefore(String) Method

Moves the current sheet before the specified sheet in a workbook.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

void MoveBefore(
    string sheetName
)

VB.NET

Sub MoveBefore(
    sheetName As String
)

Parameters

Name	Type	Description
sheetName	String	A string specifying the name of the sheet before which the current sheet should be inserted. If a sheet under the specified name is not found, an exception occurs.

Remarks

The table below lists methods of the Sheet object that allow you to rearrange worksheets and chart sheets within a workbook.

Method	Description
MoveBefore	Moves the sheet before the specified sheet in a workbook.
Sheet.MoveAfter	Moves the sheet after the specified sheet in a workbook.
Sheet.MoveToBeginning	Moves the sheet to the first position within a workbook.
Sheet.MoveToEnd	Moves the sheet to the last position within a workbook.

You can also use the Worksheet.Move and ChartSheet.Move methods to relocate worksheets and chart sheet within the WorksheetCollection and ChartSheetCollection collections, respectively.