LoadDataFilterOptions Enum
Contents
[
Hide
]LoadDataFilterOptions Enum
Represents the options to filter data when loading workbook from template.
type LoadDataFilterOptions int32
Fields
| Field | Description |
|---|---|
| All | Load all |
| CellBlank | Load cells whose value is blank |
| CellString | Load cells whose value is string |
| CellNumeric | Load cells whose value is numeric(including datetime) |
| CellError | Load cells whose value is error |
| CellBool | Load cells whose value is bool |
| CellValue | Load cells value(all value types) only |
| Formula | Load cell formulas. |
| CellData | Load cells data including values, formulas and formatting |
| Chart | Load charts |
| Drawing | Drawing objects(including Chart, Picture, OleObject and all other drawing objects) |
| MergedArea | Load merged cells |
| ConditionalFormatting | Load conditional formatting |
| DataValidation | Load data validations |
| PivotTable | Load pivot tables |
| Table | Load tables |
| Hyperlinks | Load hyperlinks |
| SheetSettings | Load settings for worksheet |
| SheetData | Load all data of worksheet, such as cells data, settings, objects, …etc. |
| BookSettings | Load settings for workbook |
| Settings | Load settings for workbook and worksheet |
| XmlMap | Load XmlMap |
| Structure | Load structure of the workbook |
| Document_Properties | Load document properties |
| DefinedNames | Load defined Name objects |
| VBA | Load VBA projects |
| Style | Load styles for cell formatting |
| Picture | Load pictures |
| OleObject | Load OleObjects |
| Revision | Load revision logs |