asposecells.api

Class LoadDataFilterOptions

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

Field Summary
const  intNONE
Load nothing for sheet data
const  intALL
Load all
const  intCELL_BLANK
Load cells whose value is blank
const  intCELL_STRING
Load cells whose value is string
const  intCELL_NUMERIC
Load cells whose value is numeric(including datetime)
const  intCELL_ERROR
Load cells whose value is error
const  intCELL_BOOL
Load cells whose value is bool
const  intCELL_VALUE
Load cells value(all value types) only
const  intFORMULA
Load cell formulas.
const  intCELL_DATA
Load cells data including values, formulas and formatting
const  intCHART
Load charts
const  intSHAPE
Load shapes
const  intDRAWING
Drawing objects(including Chart, Picture, OleObject and all other drawing objects)
const  intMERGED_AREA
Load merged cells
const  intCONDITIONAL_FORMATTING
Load conditional formatting
const  intDATA_VALIDATION
Load data validations
const  intPIVOT_TABLE
Load pivot tables
const  intTABLE
Load tables
const  intHYPERLINKS
Load hyperlinks
const  intSHEET_SETTINGS
Load settings for worksheet
const  intSHEET_DATA
Load all data of worksheet, such as cells data, settings, objects, ...etc.
const  intBOOK_SETTINGS
Load settings for workbook
const  intSETTINGS
Load settings for workbook and worksheet
const  intXML_MAP
Load XmlMap
const  intSTRUCTURE
Load structure of the workbook
const  intDOCUMENT_PROPERTIES
Load document properties
const  intDEFINED_NAMES
Load defined Name objects
const  intVBA
Load VBA projects
const  intSTYLE
Load styles for cell formatting
const  intPICTURE
Load pictures
const  intOLE_OBJECT
Load OleObjects
const  intREVISION
Load revision logs
 

    • Field Detail

      • NONE

        const int 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 int ALL
        Load all
      • CELL_BLANK

        const int CELL_BLANK
        Load cells whose value is blank
      • CELL_STRING

        const int CELL_STRING
        Load cells whose value is string
      • CELL_NUMERIC

        const int CELL_NUMERIC
        Load cells whose value is numeric(including datetime)
      • CELL_ERROR

        const int CELL_ERROR
        Load cells whose value is error
      • CELL_BOOL

        const int CELL_BOOL
        Load cells whose value is bool
      • CELL_VALUE

        const int CELL_VALUE
        Load cells value(all value types) only
      • FORMULA

        const int 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 int CELL_DATA
        Load cells data including values, formulas and formatting
      • CHART

        const int CHART
        Load charts
      • SHAPE

        const int 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 int DRAWING
        Drawing objects(including Chart, Picture, OleObject and all other drawing objects)
      • MERGED_AREA

        const int MERGED_AREA
        Load merged cells
      • CONDITIONAL_FORMATTING

        const int CONDITIONAL_FORMATTING
        Load conditional formatting
      • DATA_VALIDATION

        const int DATA_VALIDATION
        Load data validations
      • PIVOT_TABLE

        const int PIVOT_TABLE
        Load pivot tables
      • TABLE

        const int TABLE
        Load tables
      • HYPERLINKS

        const int HYPERLINKS
        Load hyperlinks
      • SHEET_SETTINGS

        const int SHEET_SETTINGS
        Load settings for worksheet
      • SHEET_DATA

        const int SHEET_DATA
        Load all data of worksheet, such as cells data, settings, objects, ...etc.
      • BOOK_SETTINGS

        const int BOOK_SETTINGS
        Load settings for workbook
      • SETTINGS

        const int SETTINGS
        Load settings for workbook and worksheet
      • XML_MAP

        const int XML_MAP
        Load XmlMap
      • STRUCTURE

        const int STRUCTURE
        Load structure of the workbook
      • DOCUMENT_PROPERTIES

        const int DOCUMENT_PROPERTIES
        Load document properties
      • DEFINED_NAMES

        const int DEFINED_NAMES
        Load defined Name objects
      • VBA

        const int VBA
        Load VBA projects
      • STYLE

        const int STYLE
        Load styles for cell formatting
      • PICTURE

        const int PICTURE
        Load pictures
      • OLE_OBJECT

        const int OLE_OBJECT
        Load OleObjects
      • REVISION

        const int REVISION
        Load revision logs