Set/Get Column Width

PUT /api/spreadsheet/setcolumnwidth

Input example (JSON)

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

Description: Sets a column width 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 column.

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

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

  • size - a float number specifying a column width.

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

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

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

Description: Returns a column width 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 column.

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

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

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

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