com.aspose.cells
Class LoadDataFilterOptions

java.lang.Object
    com.aspose.cells.LoadDataFilterOptions

public class LoadDataFilterOptions 
extends java.lang.Object

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.

public static final int ALL

Load all

public static final int CELL_BLANK

Load cells whose value is blank

public static final int CELL_STRING

Load cells whose value is string

public static final int CELL_NUMERIC

Load cells whose value is numeric(including datetime)

public static final int CELL_ERROR

Load cells whose value is error

public static final int CELL_BOOL

Load cells whose value is bool

public static final int CELL_VALUE

Load cells value(all value types) only

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.

public static final int CELL_DATA

Load cells data including values, formulas and formatting

public static final int CHART

Load charts

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

public static final int DRAWING

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

public static final int MERGED_AREA

Load merged cells

public static final int CONDITIONAL_FORMATTING

Load conditional formatting

public static final int DATA_VALIDATION

Load data validations

public static final int PIVOT_TABLE

Load pivot tables

public static final int TABLE

Load tables

public static final int HYPERLINKS

Load hyperlinks

public static final int SHEET_SETTINGS

Load settings for worksheet

public static final int SHEET_DATA

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

public static final int BOOK_SETTINGS

Load settings for workbook

public static final int SETTINGS

Load settings for workbook and worksheet

public static final int XML_MAP

Load XmlMap

public static final int STRUCTURE

Load structure of the workbook

public static final int DOCUMENT_PROPERTIES

Load document properties

public static final int DEFINED_NAMES

Load defined Name objects

public static final int VBA

Load VBA projects

public static final int STYLE

Load styles for cell formatting

public static final int PICTURE

Load pictures

public static final int OLE_OBJECT

Load OleObjects

public static final int REVISION

Load revision logs