com.aspose.cells

com.aspose.cells

Class LoadDataFilterOptions

  • java.lang.Object
    • com.aspose.cells.LoadDataFilterOptions
public class LoadDataFilterOptions 
extends java.lang.Object

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

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

    • Field Detail

      • NONE

        public static final 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

        public static final int ALL
        Load all

      • CELL_BLANK

        public static final int CELL_BLANK
        Load cells whose value is blank

      • CELL_STRING

        public static final int CELL_STRING
        Load cells whose value is string

      • CELL_NUMERIC

        public static final int CELL_NUMERIC
        Load cells whose value is numeric(including datetime)

      • CELL_ERROR

        public static final int CELL_ERROR
        Load cells whose value is error

      • CELL_BOOL

        public static final int CELL_BOOL
        Load cells whose value is bool

      • CELL_VALUE

        public static final int CELL_VALUE
        Load cells value(all value types) only

      • FORMULA

        public static final 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

        public static final int CELL_DATA
        Load cells data including values, formulas and formattings

      • CHART

        public static final int CHART
        Load charts

      • SHAPE

        public static final int 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.

      • DRAWING

        public static final int DRAWING
        Drawing objects(including Chart, Picture, OleObject and all other drawing objects)

      • MERGED_AREA

        public static final int MERGED_AREA
        Load merged cells

      • CONDITIONAL_FORMATTING

        public static final int CONDITIONAL_FORMATTING
        Load conditional formattings

      • DATA_VALIDATION

        public static final int DATA_VALIDATION
        Load data validations

      • PIVOT_TABLE

        public static final int PIVOT_TABLE
        Load pivot tables

      • TABLE

        public static final int TABLE
        Load tables

      • HYPERLINKS

        public static final int HYPERLINKS
        Load hyperlinks

      • SHEET_SETTINGS

        public static final int SHEET_SETTINGS
        Load settings for worksheet

      • SHEET_DATA

        public static final int SHEET_DATA
        Load all data of worksheet, such as cells dadta, settings, objects, ...etc.

      • BOOK_SETTINGS

        public static final int BOOK_SETTINGS
        Load settings for workbook

      • SETTINGS

        public static final int SETTINGS
        Load settings for workbook and worksheet

      • XML_MAP

        public static final int XML_MAP
        Load XmlMap

      • STRUCTURE

        public static final int STRUCTURE
        Load structure of the workbook

      • DOCUMENT_PROPERTIES

        public static final int DOCUMENT_PROPERTIES
        Load document properties

      • DEFINED_NAMES

        public static final int DEFINED_NAMES
        Load defined Name objects

      • VBA

        public static final int VBA
        Load VBA projects

      • STYLE

        public static final int STYLE
        Load styles for cell formatting

      • PICTURE

        public static final int PICTURE
        Load pictures

      • OLE_OBJECT

        public static final int OLE_OBJECT
        Load OleObjects