Set/Get Cell Values

PUT /api/spreadsheet/setcellvalue

Input example (JSON)

{
"id": "some_id",
"filename": "test",
"extension": "xls",
"sheetindex": 0,
"sheetname": "Sheet1",
"rowindex": 0,
"columnindex": 0,
"value": 5
}

Description: Sets a cell value.

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 cell belongs.

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

  • sheetindex - a zero-based index of the worksheet that contains a cell.

  • sheetname - a name of the worksheet that contains a cell.

  • rowindex - a zero-based index of the row that contains a cell.

  • columnindex - a zero-based index of the column that contains a cell.

  • value - an object that specifies the cell value.


GET /api/spreadsheet/getcellvalue?id&filename&extension&sheetindex&sheetname&rowindex&columnindex

Description: Gets a cell value.

Parameters

  • 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 cell belongs.

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

  • sheetindex - a zero-based index of the worksheet that contains a cell.

  • sheetname - a name of the worksheet that contains a cell.

  • rowindex - a zero-based index of the row that contains a cell.

  • columnindex - a zero-based index of the column that contains a cell.


POST /api/spreadsheet/getcellvalues?id&filename&extension&sheetindex&sheetname&rowindex&columnindex&id1&filename1&extension1&sheetindex1&sheetname1&rowindex1&columnindex1&...

Description: Gets values of the specified cells. Each cell is specified by the parameters below.

Parameters

  • 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 cells belong.

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

  • sheetindex - a zero-based index of the worksheet that contains cells.

  • sheetname - a name of the worksheet that contains cells.

  • rowindex - a zero-based index of the row that contains cells.

  • columnindex - a zero-based index of the column that contains cells.