Reference>IXLSRange>MergeCells

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

Syntax

property MergeCells: Boolean;

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;