Moves the worksheet to another location within the workbook’s collection of worksheets.
An integer value specifying the zero-based destination index of the moved worksheet.
When you move worksheets in the document, a hidden worksheet can occupy the position of the currently active worksheet. In this case, the next visible worksheet to the right of this hidden worksheet will be automatically activated. If there are no visible worksheets to the right of the hidden worksheet, the first visible worksheet to the left of this worksheet becomes active.
This example demonstrates how to move a worksheet to another location in a workbook. To do this, call the Worksheet.Move method and pass the worksheet zero-based index specifying the position in the WorksheetCollection collection into which the worksheet should be moved.
A complete sample project is available at https://github.com/DevExpress-Examples/spreadsheet-document-server-api-e4339
// Move the first worksheet to the position of the last worksheet within the workbook. workbook.Worksheets.Move(workbook.Worksheets.Count - 1);