Move Worksheets within Workbook
Aspose.Cells provides a method, Aspose.Cells.Worksheet.MoveTo(), used to move a worksheet to another location in the spreadsheet. The method takes the target worksheet index as a parameter.
The following example shows how to move a worksheet to another location within the workbook.
string FilePath = @"..\..\..\Sample Files\"; string FileName = FilePath + "Move Worksheet.xlsx"; //Open an existing excel file. Workbook wb = new Workbook(FileName); //Create a Worksheets object with reference to //the sheets of the Workbook. WorksheetCollection sheets = wb.Worksheets; //Get the first worksheet. Worksheet worksheet = sheets; string test = worksheet.Name; //Move the first sheet to the third position in the workbook. worksheet.MoveTo(2); //Save the excel file. wb.Save(FileName);