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