Skip to main content
Row

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

void MoveBefore(
    string sheetName
)

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.

See Also