Click or drag to resize

IXLSRange Merge Method (IXLSRange)

Returns merge of this range with the specified one.
Examples
The following code illustrates how to check whether two ranges are mergable or not:
Copy 
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Merge range</para><para>worksheet["A2:B2"].Merge();</para><para>//Get mergable range</para><para>IXLSRange mergableRange = worksheet["A2"].MergeArea.Merge(worksheet["C2"]);</para><para>//Check mergable Area</para><para>Console.Write(mergableRange.RangeAddressLocal);</para><para>//Save to file</para><para>workbook.SaveToFile("Intersect.xlsx");</para>

Namespace: Spire.Xls.Core
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
Copy 
IXLSRange Merge(
	IXLSRange range
)

Parameters

range
Type: Spire.Xls.Core IXLSRange
The Range to merge with.

Return Value

Type: IXLSRange
Merged ranges or NULL if wasn't able to merge ranges.
See Also