aspose.cells
Class LoadDataFilterOptions

Utility class containing constants. Represents the options to filter data when loading workbook from template.

Field Summary
const  NumberNONE
           Load nothing for sheet data
const  NumberALL
           Load all
const  NumberCELL_BLANK
           Load cells whose value is blank
const  NumberCELL_STRING
           Load cells whose value is string
const  NumberCELL_NUMERIC
           Load cells whose value is numeric(including datetime)
const  NumberCELL_ERROR
           Load cells whose value is error
const  NumberCELL_BOOL
           Load cells whose value is bool
const  NumberCELL_VALUE
           Load cells value(all value types) only
const  NumberFORMULA
           Load cell formulas.
const  NumberCELL_DATA
           Load cells data including values, formulas and formatting
const  NumberCHART
           Load charts
const  NumberSHAPE
           Load shapes
const  NumberDRAWING
           Drawing objects(including Chart, Picture, OleObject and all other drawing objects)
const  NumberMERGED_AREA
           Load merged cells
const  NumberCONDITIONAL_FORMATTING
           Load conditional formatting
const  NumberDATA_VALIDATION
           Load data validations
const  NumberPIVOT_TABLE
           Load pivot tables
const  NumberTABLE
           Load tables
const  NumberHYPERLINKS
           Load hyperlinks
const  NumberSHEET_SETTINGS
           Load settings for worksheet
const  NumberSHEET_DATA
           Load all data of worksheet, such as cells data, settings, objects, ...etc.
const  NumberBOOK_SETTINGS
           Load settings for workbook
const  NumberSETTINGS
           Load settings for workbook and worksheet
const  NumberXML_MAP
           Load XmlMap
const  NumberSTRUCTURE
           Load structure of the workbook
const  NumberDOCUMENT_PROPERTIES
           Load document properties
const  NumberDEFINED_NAMES
           Load defined Name objects
const  NumberVBA
           Load VBA projects
const  NumberSTYLE
           Load styles for cell formatting
const  NumberPICTURE
           Load pictures
const  NumberOLE_OBJECT
           Load OleObjects
 

Field Detail

NONE

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.

ALL

const Number ALL
Load all

CELL_BLANK

const Number CELL_BLANK
Load cells whose value is blank

CELL_STRING

const Number CELL_STRING
Load cells whose value is string

CELL_NUMERIC

const Number CELL_NUMERIC
Load cells whose value is numeric(including datetime)

CELL_ERROR

const Number CELL_ERROR
Load cells whose value is error

CELL_BOOL

const Number CELL_BOOL
Load cells whose value is bool

CELL_VALUE

const Number CELL_VALUE
Load cells value(all value types) only

FORMULA

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.

CELL_DATA

const Number CELL_DATA
Load cells data including values, formulas and formatting

CHART

const Number CHART
Load charts

SHAPE

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

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

MERGED_AREA

const Number MERGED_AREA
Load merged cells

CONDITIONAL_FORMATTING

const Number CONDITIONAL_FORMATTING
Load conditional formatting

DATA_VALIDATION

const Number DATA_VALIDATION
Load data validations

PIVOT_TABLE

const Number PIVOT_TABLE
Load pivot tables

TABLE

const Number TABLE
Load tables

HYPERLINKS

const Number HYPERLINKS
Load hyperlinks

SHEET_SETTINGS

const Number SHEET_SETTINGS
Load settings for worksheet

SHEET_DATA

const Number SHEET_DATA
Load all data of worksheet, such as cells data, settings, objects, ...etc.

BOOK_SETTINGS

const Number BOOK_SETTINGS
Load settings for workbook

SETTINGS

const Number SETTINGS
Load settings for workbook and worksheet

XML_MAP

const Number XML_MAP
Load XmlMap

STRUCTURE

const Number STRUCTURE
Load structure of the workbook

DOCUMENT_PROPERTIES

const Number DOCUMENT_PROPERTIES
Load document properties

DEFINED_NAMES

const Number DEFINED_NAMES
Load defined Name objects

VBA

const Number VBA
Load VBA projects

STYLE

const Number STYLE
Load styles for cell formatting

PICTURE

const Number PICTURE
Load pictures

OLE_OBJECT

const Number OLE_OBJECT
Load OleObjects

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.