Create Worksheets

POST /api/spreadsheet/createworksheet

Input example (JSON)

{
"id": "some_id",
"filename": "test",
"extension": "xls",
"name": "Sheet1",
"index": 0
}

Description: Creates a new worksheet with the specified name and index.

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 a worksheet is added.

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

  • name - a string value that specifies the name of the created worksheet.

  • index - a zero-based index of the created worksheet. If the document already contains a worksheet with the specified index, a new worksheet is added to the position specified by the index and all of the remaining worksheets are moved to the end of the document.