officefileapi-devexpress-dot-spreadsheet-dot-sheet-dot-movebefore-x28-system-dot-string-x29.md
Moves the current sheet before the specified sheet in a workbook.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
void MoveBefore(
string sheetName
)
Sub MoveBefore(
sheetName As String
)
| 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