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);