The setSheetOrder function is established to move a sheet's position.
var excel = new Excel("test.xlsx");
excel.createSheet("newSheet").setSheetOrder("newSheet", 1);
| Calling | Returning |
|---|---|
| Excel . setSheetOrder ( sheetName , order ) | Excel |
| Parameters | Type | Description |
|---|---|---|
| sheetName | String | The sheet name. |
| order | Number | The position of the sheet.Starting from 1. |