Show Rows and Columns

PUT /api/spreadsheet/unhiderows

Input example (JSON)

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

Description: Shows hidden 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 that specifies the file name of the document to which rows belong.

  • extension - a string value that specifies 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 that specifies the name of the worksheet to which rows belong.

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

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


PUT /api/spreadsheet/unhidecolumns

Input example (JSON)

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

Description: Shows hidden 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 that specifies the file name of the document to which columns belong.

  • extension - a string value that specifies 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 that specifies the name of the worksheet to which columns belong.

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

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