LoadDataFilterOptions
Contents
[
Hide
]LoadDataFilterOptions enumeration
Utility class containing constants. Represents the options to filter data when loading workbook from template.
Values
| Name | Description |
|---|---|
| NONE | Load nothing for sheet data NOTE: This member is now obsolete and please use Structure instead. This property will be removed 12 months later since December 2017. Aspose apologizes for any inconvenience you may have experienced. |
| ALL | Load all |
| CELL_BLANK | Load cells whose value is blank |
| CELL_STRING | Load cells whose value is string |
| CELL_NUMERIC | Load cells whose value is numeric(including datetime) |
| CELL_ERROR | Load cells whose value is error |
| CELL_BOOL | Load cells whose value is bool |
| CELL_VALUE | Load cells value(all value types) only |
| FORMULA | Load cell formulas. Generally defined Name objects(DefinedNames) also need to be loaded when loading formulas because they may be referenced by formulas. So Formula or CellData option should work with DefinedNames option together(Formula|DefinedNames or CellData|DefinedNames) for most scenarios. |
| CELL_DATA | Load cells data including values, formulas and formatting |
| CHART | Load charts |
| SHAPE | Load shapes NOTE: This member is now obsolete and please use Drawing instead. This property will be removed 12 months later since November 2019. Aspose apologizes for any inconvenience you may have experienced. |
| DRAWING | Drawing objects(including Chart, Picture, OleObject and all other drawing objects) |
| MERGED_AREA | Load merged cells |
| CONDITIONAL_FORMATTING | Load conditional formatting |
| DATA_VALIDATION | Load data validations |
| PIVOT_TABLE | Load pivot tables |
| TABLE | Load tables |
| HYPERLINKS | Load hyperlinks |
| SHEET_SETTINGS | Load settings for worksheet |
| SHEET_DATA | Load all data of worksheet, such as cells data, settings, objects, …etc. |
| BOOK_SETTINGS | Load settings for workbook |
| SETTINGS | Load settings for workbook and worksheet |
| XML_MAP | Load XmlMap |
| STRUCTURE | Load structure of the workbook |
| DOCUMENT_PROPERTIES | Load document properties |
| DEFINED_NAMES | Load defined Name objects |
| VBA | Load VBA projects |
| STYLE | Load styles for cell formatting |
| PICTURE | Load pictures |
| OLE_OBJECT | Load OleObjects |
| REVISION | Load revision logs |