hideColumn - cfsimplicity/spreadsheet-cfml GitHub Wiki

Sets the format of the specified column to hidden.

hideColumn( workbook, column )

Required arguments

• workbook spreadsheet object
• column numeric

Chainable? Yes.

Example

data = QueryNew( "First,Last","VarChar,VarChar",[ [ "a","b" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.hideColumn( workbook,2 );