InternalNameRange 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
Namespace: 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:
TXlsNamedRange printArea = xls.GetNamedRange(TXlsNamedRange.GetInternalName(InternalNameRange.Print_Area), xls.ActiveSheet);