SpreadsheetFormatColumns

Formats multiple columns of an Excel spreadsheet object.

Method Signature

SpreadsheetFormatColumns(spreadsheetObj=[any], format=[any], columns=[any])

Arguments

Argument	Type	Required	Description	Default
spreadsheetObj	ANY	true	The spreadsheet object.
format	STRUCT	true	A structure containing formatting options (bold, italic, color, etc.).
columns	STRING	true	The columns to format, in one of the following formats: * - startColumn-endColumn for a range (e.g., "1-5") * - column,column,column for individual columns (e.g., "1,3,5") * - combinations like "1-3,5,7-10"

Examples

Format multiple columns:

// Format columns 2-4 with same style
var spreadsheet = SpreadsheetNew();
var format = { alignment = "right", numFmt = "$#,##0.00" };
SpreadsheetFormatColumns( spreadsheet, 2, 3, format );

Related

• SpreadsheetFormatColumn() - Format single column

• SpreadsheetFormatRows() - Format rows