HotXLS Docs

MergeCells property

True if the range contains merged cells. Read/write Boolean.

Syntax

property MergeCells: Boolean;

Example

This example sets the value of the merged range that contains cell A3.

With Workbook.sheets[1].Range['A3','A3'] do begin
  if MergeCells then MergeArea[1,1].Value := 100;
end;
This example merges A1:F1 cells on sheet one.

Workbook.Sheets[1].Range['A1', 'F1'].MergeCells := true;