Skip to main content

hideRows()

Description​

Hides rows

Usage​

hideRows(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.hideRows("B2"); // the "2" row will be hidden 
spreadsheet.hideRows("sheet2!B2"); // the "2" row in "sheet2" will be hidden 
spreadsheet.hideRows("B2:C4"); // the rows from "2" to "4" will be hidden

Related articles: Work with Spreadsheet

Related API: showRows()

Related sample: Spreadsheet. Hiding columns and rows via API

Change log: Added in v5.2