Skip to main content

hideCols()

Description​

Hides columns

Usage​

hideCols(cell?: string): void;

Parameters​

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

Example​

spreadsheet.hideCols("B2"); // the "B" column will be hidden
spreadsheet.hideCols("sheet2!B2"); // the "B" column in "sheet2" will be hidden
spreadsheet.hideCols("B2:C2"); // the "B" and "C" columns will be hidden

Related articles: Work with Spreadsheet

Related API: showCols()

Related sample: Spreadsheet. Hiding columns and rows via API

Change log: Added in v5.2