Enum GridLoadDataFilterOptions

GridLoadDataFilterOptions enumeration

Represents the options to filter data when loading workbook from template.

public enum GridLoadDataFilterOptions

Name	Value	Description
All	`2147483647`	Load all
CellBlank	`1`	Load cells whose value is blank
CellString	`2`	Load cells whose value is string
CellNumeric	`4`	Load cells whose value is numeric(including datetime)
CellError	`8`	Load cells whose value is error
CellBool	`16`	Load cells whose value is bool
CellValue	`31`	Load cells value(all value types) only
Formula	`32`	Load cell formulas.
CellData	`67108927`	Load cells data including values, formulas and formatting
Chart	`256`	Load charts
Drawing	`402653952`	Drawing objects(including Chart, Picture, OleObject and all other drawing objects)
MergedArea	`1024`	Load merged cells
ConditionalFormatting	`2048`	Load conditional formatting
DataValidation	`4096`	Load data validations
PivotTable	`8192`	Load pivot tables
Table	`16384`	Load tables
Hyperlinks	`32768`	Load hyperlinks
SheetSettings	`65536`	Load settings for worksheet
SheetData	`403701759`	Load all data of worksheet, such as cells data, settings, objects, …etc.
BookSettings	`1048576`	Load settings for workbook
Settings	`1114112`	Load settings for workbook and worksheet
XmlMap	`2097152`	Load XmlMap
Structure	`4194304`	Load structure of the workbook
DocumentProperties	`8388608`	Load document properties
DefinedNames	`16777216`	Load defined Name objects
VBA	`33554432`	Load VBA projects
Style	`67108864`	Load styles for cell formatting
Picture	`134217728`	Load pictures
OleObject	`268435456`	Load OleObjects
Revision	`536870912`	Load revision logs