TInternalNameRange Enumeration
List of internal range names.
On Excel, internal range names like "Print_Area" are stored as a 1 character string.
This is the list of the names and their value.
You can convert an InternalNameRange into a string by casting it to a char, or by calling TXlsNamedRange.GetInternalName
Syntax
Unit: FlexCel.Core
Members
| Name |
Value |
Description |
| Consolidate_Area |
0 |
Consolidate_Area |
| Auto_Open |
1 |
Auto_Open |
| Auto_Close |
2 |
Auto_Close |
| Extract |
3 |
Extract |
| Database |
4 |
Database |
| Criteria |
5 |
Criteria |
| Print_Area |
6 |
Print_Area |
| Print_Titles |
7 |
Print_Titles |
| Recorder |
8 |
Recorder |
| Data_Form |
9 |
Data_Form |
| Auto_Activate |
10 |
Auto_Activate |
| Auto_Deactivate |
11 |
Auto_Deactivate |
| Sheet_Title |
12 |
Sheet_Title |
| Filter_DataBase |
13 |
Used in AutoFilters. |
Examples
To get the print range on the ActiveSheet, use:
printArea := xls.GetNamedRange(TXlsNamedRange.GetInternalName(TInternalNameRange.Print_Area), xls.ActiveSheet);