Set/Get Formula

PUT /api/spreadsheet/setformula

Input example (JSON)

{
"id": "some_id",
"filename": "test",
"extension": "xls",
"sheetindex": 0,
"sheetname": "Sheet1",
"rowindex": 0,
"columnindex": 0,
"value": "=A1*B1"
}

Description: Adds a formula to a cell.

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 that contains a cell.

  • extension - a string value that specifies the file extension of the document that contains a cell. 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 - a string value expression that represents a formula added to a cell. It starts with an equal sign (=).


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

Description: Gets a formula contained in a cell.

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 that contains a cell.

  • extension - a string value that specifies the file extension of the document that contains a cell. 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.