SpreadsheetMergeCells

Merges a rectangular block of two or more Excel spreadsheet object cells.

Method Signature

SpreadsheetMergeCells(spreadsheetObj=[any], startRow=[any], startColumn=[any], endRow=[any], endColumn=[any])

Arguments

Argument	Type	Required	Description	Default
spreadsheetObj	ANY	true	The spreadsheet object.
startRow	NUMERIC	true	The starting row number (1-based).
startColumn	NUMERIC	true	The starting column number (1-based).
endRow	NUMERIC	true	The ending row number (1-based).
endColumn	NUMERIC	true	The ending column number (1-based).

Examples

Merge cells for titles:

// Merge cells A1:D1 for title
var spreadsheet = SpreadsheetNew();
SpreadsheetAddRow( spreadsheet, [ "Report Title", "", "", "" ] );

SpreadsheetMergeCells( spreadsheet, 1, 1, 1, 4 );
SpreadsheetFormatCell( spreadsheet, 1, 1, { bold = true, alignment = "center" } );

Related

• SpreadsheetFormatCell() - Format cell

• SpreadsheetFormatCellRange() - Format range

• Formatting Guide - Cell styling