Get Hidden Rows and Columns

GET /api/spreadsheet/gethiddenrows?id&sheetindex&sheetname&startindex&endindex

Description: Gets a list of hidden rows.

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 hidden rows.

  • sheetname - a name of the worksheet that contains hidden rows.

  • startindex - a zero-based index of the first row from which to search for hidden rows.

  • endindex - a zero-based index of the last row until which to search for hidden rows.


GET /api/spreadsheet/gethiddencolumns?id&sheetindex&sheetname&startindex&endindex

Description: Gets a list of hidden columns.

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 hidden columns.

  • sheetname - a name of the worksheet that contains hidden columns.

  • startindex - a zero-based index of the first column from which to search for hidden columns.

  • endindex - a zero-based index of the last column until which to search for hidden columns