TXlsNamedRange.GetRanges Method
Overloads
TXlsNamedRange.GetRanges(ExcelFile)
Returns a list of ranges and cells included in this name. This can be used to parse for example the PRINT_TITLES range, which might be something like "1:1,A:A". ("," is the union operator in Excel formulas).This method would return an array with the ranges 1:1 and A:A.
Syntax
Namespace: FlexCel.Core
public TXlsCellRange[] GetRanges(ExcelFile Workbook)Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| Workbook | ExcelFile | File which contains this range. |
See also
TXlsNamedRange.GetRanges(ExcelFile, Int32)
Returns a list of ranges and cells included in this name. This can be used to parse for example the PRINT_TITLES range, which might be something like "1:1,A:A". ("," is the union operator in Excel formulas).This method would return an array with the ranges 1:1 and A:A.
Syntax
Namespace: FlexCel.Core
public TXlsCellRange[] GetRanges(ExcelFile Workbook, Int32 targetSheet)Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| Workbook | ExcelFile | File which contains this range. | |
| targetSheet | Int32 | Sheet to target (1-based). If any of the ranges does not refer to targetSheet, this method will return null. To ignore targetSheet and return all ranges, set targetSheet to 0 or to a negative value. |