Change Worksheet Index

PUT /api/spreadsheet/changesheetindex

Input example (JSON)

{
"id": "some_id",
"filename": "test",
"extension": "xls",
"sheetname": "Sheet1",
"oldsheetindex": 1,
"newsheetindex": 2
}

Description: Moves the worksheet to another position within the document.

JSON fields

  • id - an identifier of a session to which the document has been loaded. This parameter's value is returned by the request used to create or load the document.

  • filename - a string value that specifies the file name of the document to which the worksheet belongs.

  • extension - a string value that specifies the file extension of the document to which a worksheet belongs. The supported file extensions are: OPENXML (XLSX), XLS and CSV.

  • sheetname - a string value that specifies the worksheet name.

  • oldsheetindex - an old zero-based index of a worksheet.

  • newsheetindex - a new zero-based index of a worksheet.