aspose.cells
Class LoadDataFilterOptions

const Number 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.

const Number ALL

Load all

const Number CELL_BLANK

Load cells whose value is blank

const Number CELL_STRING

Load cells whose value is string

const Number CELL_NUMERIC

Load cells whose value is numeric(including datetime)

const Number CELL_ERROR

Load cells whose value is error

const Number CELL_BOOL

Load cells whose value is bool

const Number CELL_VALUE

Load cells value(all value types) only

const Number 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.

const Number CELL_DATA

Load cells data including values, formulas and formattings

const Number CHART

Load charts

const Number SHAPE

Load shapes

NOTE: This member is now obsolete and please use Structure instead. This property will be removed 12 months later since November 2019. Aspose apologizes for any inconvenience you may have experienced.

const Number DRAWING

Drawing objects(including Chart, Picture, OleObject and all other drawing objects)

const Number MERGED_AREA

Load merged cells

const Number CONDITIONAL_FORMATTING

Load conditional formattings

const Number DATA_VALIDATION

Load data validations

const Number PIVOT_TABLE

Load pivot tables

const Number TABLE

Load tables

const Number HYPERLINKS

Load hyperlinks

const Number SHEET_SETTINGS

Load settings for worksheet

const Number SHEET_DATA

Load all data of worksheet, such as cells dadta, settings, objects, ...etc.

const Number BOOK_SETTINGS

Load settings for workbook

const Number SETTINGS

Load settings for workbook and worksheet

const Number XML_MAP

Load XmlMap

const Number STRUCTURE

Load structure of the workbook

const Number DOCUMENT_PROPERTIES

Load document properties

const Number DEFINED_NAMES

Load defined Name objects

const Number VBA

Load VBA projects

const Number STYLE

Load styles for cell formatting

const Number PICTURE

Load pictures

const Number OLE_OBJECT

Load OleObjects