CellRange Intersect Method |
Overload List
| Name | Description | |
|---|---|---|
|
Intersect(CellRange) |
Get intersection range with the specified range.
|
|
Intersect(IXLSRange) |
Returns intersection of this range with the specified one.
(Inherited from
XlsRange
.)
Examples
The following code illustrates how to perform intersectwith in the Range:
<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Get intersect range</para><para>IXLSRange range = worksheet.Range["A16:C16"];</para><para>IXLSRange commonRange = worksheet.Range["B16:D16"].Intersect(range);</para><para>//Save to file</para><para>workbook.SaveToFile("Intersect.xlsx");</para>
|
See Also
