Hide Rows and Columns

PUT /api/spreadsheet/hiderows

Input example (JSON)

{
"id": "some_id",
"filename": "test",
"extension": "xls",
"sheetindex": 0,
"sheetname": "Sheet1",
"startindex": 1,
"endindex": 2
}

Description: Hides specified rows.

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 specifying the file name of the document to which rows belong.

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

  • sheetindex - a zero-based index of the worksheet to which rows belong.

  • sheetname - a string value specifying the name of the worksheet to which rows belong.

  • startindex - a zero-based index of the first row to be hidden.

  • endindex - a zero-based index of the last row to be hidden.


PUT /api/spreadsheet/hidecolumns

Input example (JSON)

{
"id": "some_id",
"filename": "test",
"extension": "xls",
"sheetindex": 0,
"sheetname": "Sheet1",
"startindex": 1,
"endindex": 2
}

Description: Hides specified columns.

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 specifying the file name of the document to which columns belong.

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

  • sheetindex - a zero-based index of the worksheet to which columns belong.

  • sheetname - a string value specifying the name of the worksheet to which columns belong.

  • startindex - a zero-based index of the first column to be hidden.

  • endindex - a zero-based index of the last column to be hidden.