TXlsNamedRange.GetRanges Method
Overloads
TXlsNamedRange.GetRanges(TCoreExcelFile)
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
Unit: FlexCel.Core
function TXlsNamedRange.GetRanges(const Workbook: TCoreExcelFile): TArray<TXlsCellRange>; overload;Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| const | Workbook | TCoreExcelFile | File which contains this range. |
See also
TXlsNamedRange.GetRanges(TCoreExcelFile, Integer)
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
Unit: FlexCel.Core
function TXlsNamedRange.GetRanges(const Workbook: TCoreExcelFile; const targetSheet: Integer): TArray<TXlsCellRange>; overload;Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| const | Workbook | TCoreExcelFile | File which contains this range. |
| const | targetSheet | Integer | 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. |