Skip to main content

showRows()

Description​

Shows hidden rows

Usage​

showRows(cell?: string): void;

Parameters​

  • cell - (optional) the id of the cell used to define the id of a row. If the cell id isn't passed, the currently selected cell will be used

Example​

spreadsheet.showRows("B2"); // the "2" row will become visible again
spreadsheet.showRows("sheet2!B2"); // the "2" row in "sheet2" will become visible again
spreadsheet.showRows("B2:C2"); // the rows from "2" to "4" will become visible again

Related articles: Work with Spreadsheet

Related API: hideRows()

Related sample: Spreadsheet. Hiding columns and rows via API

Change log: Added in v5.2