Order of Worksheets

Aspose.Cells Product Family
1

Is there any way to change order of worksheets in Excel::Worksheets collection?
Or how can I add a new worksheet as the specified index?
Thanks…

2

Sure you can. Please check http://www.aspose.com/Products/Aspose.Excel/Api/Aspose.Excel.Worksheet.Move.html

3

Thanks a lot! (I just thought it should be some method of Worksheets)

4

@Antoine,
Aspose.Excel is discarded and no more development is done for it. A new product Aspose.Cells is introduced which contains all the features of Aspose.Excel along with the support for the latest feature of MS Excel. This new product also contains features for copying and moving the worksheets in a workbook. Followiing is an example which demonstrates the Move function using Aspose.Cells.

string InputPath = dataDir + "book1.xls";

// Open an existing excel file.
Workbook wb = new Workbook(InputPath);

// Create a Worksheets object with reference to
// the sheets of the Workbook.
WorksheetCollection sheets = wb.Worksheets;

// Get the first worksheet.
Worksheet worksheet = sheets[0];

// Move the first sheet to the third position in the workbook.
worksheet.MoveTo(2);

// Save the excel file.
wb.Save(dataDir + "MoveWorksheet_out.xls");

You can find more information about copying and moving worksheets here:
Copying and Moving Worksheets

Download the latest trial version here:
Aspose.Cells for .NET (Latest Version)

Download a complete runnable solution here to test variety of features of this product.