Reorder

You can arrange the order of tablesheets and worksheets together at runtime according to your own preferences. This operation can be performed by reordering the tabs of tab strip. You can even place tablesheets before and between the worksheets and vice versa.

reordertb

You can also toggle the position of the sheet by using changeSheetPosition and getSheetPosition methods. Use the getSheetPosition method to retrieve the current position of the sheet (either worksheet or tablesheet) and then use the changeSheetPosition method to change the position and reorder the sheets.

Use the following code sample to assign a new position to the tablesheet and retrieve its current position.

// Change the position of TableSheet1.
spread.changeSheetPosition("TableSheet1", 1); 
// Retrieve the current position of the TableSheet1.
var position = spread.getSheetPosition("TableSheet1");