autoSizeColumn

Jump to bottom Edit New page

Julian Halliwell edited this page Sep 20, 2021 · 4 revisions

Adjusts the width of the specified column to fit the contents.

autoSizeColumn( workbook, column[, useMergedCells ] )

Required arguments

workbook spreadsheet object
column numeric

Optional arguments

useMergedCells boolean default=false: whether to use the contents of merged cells when calculating the width of the column.

Chainable? Yes.

Example

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