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. |
See also