-
-
Notifications
You must be signed in to change notification settings - Fork 36
autoSizeColumn
Julian Halliwell edited this page Feb 25, 2015
·
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.
##Example
data = QueryNew( "First,Last","VarChar,VarChar",[ [ "a","abracadabraabracadabra" ] ] );
spreadsheet = New spreadsheet();
workbook = spreadsheet.workbookFromQuery( data );
spreadsheet.autoSizeColumn( workbook,2 );