SpreadsheetFormatRows

Formats multiple rows of an Excel spreadsheet object.

Method Signature

SpreadsheetFormatRows(spreadsheetObj=[any], format=[any], rows=[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.).
rows	STRING	true	The rows to format, in one of the following formats: * - startRow-endRow (e.g., "1-5") - Formats rows in a single range * - row,row,row... (e.g., "1,3,5") - Formats individual rows * - Combinations allowed (e.g., "1-5,6,7,9-12")

Examples

Format multiple rows:

// Apply formatting to rows 1-5
var spreadsheet = SpreadsheetNew();
var format = { bold = false, background = "F5F5F5" };
SpreadsheetFormatRows( spreadsheet, 1, 5, format );

Related

• SpreadsheetFormatRow() - Format single row

• SpreadsheetFormatColumns() - Format columns