spreadsheetSetColumnHidden

Hides or shows a column.

spreadsheetSetColumnHidden(spreadsheet, column, hide) → returns void

Argument Reference

spreadsheet any
Required

The spreadsheet object.

column numeric
Required

Column number (1-based).

hide boolean
Required

true to hide the column, false to show it.
Values:
  • true
  • false

Compatibility

RustCFML:

Not supported on wasm32. The third argument is named hidden (default true). Member forms: setColumnHidden(column, hidden), hideColumn(column), showColumn(column), isColumnHidden(column).

Examples
Sample code invoking the spreadsheetSetColumnHidden function

Hide column 3 and check its hidden state.

wb = Spreadsheet("xlsx");
spreadsheetSetColumnHidden(wb, 3, true);
writeDump(wb.isColumnHidden(3));

Expected Result: true

Signup for cfbreak to stay updated on the latest news from the ColdFusion / CFML community. One email, every friday.

Fork me on GitHub