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: (20.10)
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 formatting
Chart256 Load charts
Shape402653696 Obsolete. Load shapes
Drawing402653952 Drawing objects(including Chart, Picture, OleObject and all other drawing objects)
MergedArea1024 Load merged cells
ConditionalFormatting2048 Load conditional formatting
DataValidation4096 Load data validations
PivotTable8192 Load pivot tables
Table16384 Load tables
Hyperlinks32768 Load hyperlinks
SheetSettings65536 Load settings for worksheet
SheetData403701759 Load all data of worksheet, such as cells data, 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
Picture134217728 Load pictures
OleObject268435456 Load OleObjects
See Also