SpreadsheetFormatColumn

Formats a column of an Excel spreadsheet object.

Method Signature

SpreadsheetFormatColumn(spreadsheetObj=[any], format=[any], column=[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.).

column

NUMERIC

true

The column number (1-based).

Examples

Format an entire column:

// Format column B with specific style
var spreadsheet = SpreadsheetNew();
var format = { bold = true, background = "CCCCCC" };
SpreadsheetFormatColumn( spreadsheet, 2, format );

Last updated

Was this helpful?