Class LookupCachingMode
Specifies options for caching look up tables in HLookUp and VLookUp functions.
Inheritance
System.Object
LookupCachingMode
Namespace: Syncfusion.XlsIO.Calculate
Assembly: Syncfusion.XlsIO.Portable.dll
Syntax
public sealed class LookupCachingMode : EnumFields
Both
Tables will be cached for both VLookUp and HLookUp.
Declaration
public const LookupCachingMode BothField Value
| Type | Description |
|---|---|
| LookupCachingMode |
HLOOKUP
Tables will be cached only for HLookUp.
Declaration
public const LookupCachingMode HLOOKUPField Value
| Type | Description |
|---|---|
| LookupCachingMode |
None
No caching is done.
Declaration
public const LookupCachingMode NoneField Value
| Type | Description |
|---|---|
| LookupCachingMode |
OptimizeForMatches
Tables will be optimized for searching for exact matches. Set this flag if you expect your searches to find exact matches.
Declaration
public const LookupCachingMode OptimizeForMatchesField Value
| Type | Description |
|---|---|
| LookupCachingMode |
value__
Declaration
public int value__Field Value
| Type | Description |
|---|---|
| System.Int32 |
VLOOKUP
Tables will be cached only for VLookUp.
Declaration
public const LookupCachingMode VLOOKUPField Value
| Type | Description |
|---|---|
| LookupCachingMode |