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
const  NumberREVISION
Load revision logs
 

    • 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
      • REVISION

        const Number REVISION
        Load revision logs