A newer version of this page is available. Switch to the current version.

Sheet.MoveBefore(String) Method

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

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v18.2.Core.dll


void MoveBefore(
    string sheetName


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.


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