Click or drag to resize
LoadDataFilterOptions Enumeration
Represents the options to filter data when loading workbook from template.

Namespace: Aspose.Cells
Assembly: Aspose.Cells (in Aspose.Cells.dll) Version: (19.11)
public enum LoadDataFilterOptions
  Member nameValueDescription
None0 Obsolete. Load nothing for sheet data
All2147483647 Load all
CellBlank1 Load cells whose value is blank
CellString2 Load cells whose value is string
CellNumeric4 Load cells whose value is numeric(including datetime)
CellError8 Load cells whose value is error
CellBool16 Load cells whose value is bool
CellValue31 Load cells value(all value types) only
Formula32 Load cell formulas.
CellData67108927 Load cells data including values, formulas and formattings
Chart256 Load charts
Shape512 Load shapes
MergedArea1024 Load merged cells
ConditionalFormatting2048 Load conditional formattings
DataValidation4096 Load data validations
PivotTable8192 Load pivot tables
Table16384 Load tables
Hyperlinks32768 Load hyperlinks
SheetSettings65536 Load settings for worksheet
SheetData1048575 Load all data of worksheet, such as cells dadta, settings, objects, ...etc.
BookSettings1048576 Load settings for workbook
Settings1114112 Load settings for workbook and worksheet
XmlMap2097152 Load XmlMap
Structure4194304 Load structure of the workbook
DocumentProperties8388608 Load document properties
DefinedNames16777216 Load defined Name objects
VBA33554432 Load VBA projects
Style67108864 Load styles for cell formatting
See Also