Set/Get Row Height

PUT /api/spreadsheet/setrowheight

Input example (JSON)

{
"id": "some_id",
"sheetindex": 0,
"sheetname": "Sheet1",
"index": 0,
"size": 1.5,
"unit": "Inch"
}

Description: Sets a row height 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.

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

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

  • index - a zero-based index of a row.

  • size - a float number specifying row height.

  • unit - an enumeration object specifying a size unit. Available units are:

    1. Pixels
    2. Points
    3. Inch
    4. Centimeters

GET /api/spreadsheet/getrowheight?id&sheetindex&sheetname&index&unit

Description: Returns a row height value in specified units.

Request 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.

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

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

  • index - a zero-based index of a row.

  • unit - an enumeration object specifying a size unit. Available units are:

    1. Pixels
    2. Points
    3. Inch
    4. Centimeters