Skip to main content

showCols()

Description​

Shows hidden columns

Usage​

showCols(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.showCols("B2"); // the "B" column will become visible again
spreadsheet.showCols("sheet2!B2"); // the "B" column in "sheet2" will become visible again
spreadsheet.showCols("B2:C2"); // the "B" and "C" columns will become visible again

Related articles: Work with Spreadsheet

Related API: hideCols()

Related sample: Spreadsheet. Hiding columns and rows via API

Change log: Added in v5.2