LoadDataFilterOptions

Inheritance: java.lang.Object

public final class LoadDataFilterOptions

Represents the options to filter data when loading workbook from template.

Fields

FieldDescription
ALLLoad all
BOOK_SETTINGSLoad settings for workbook
CELL_BLANKLoad cells whose value is blank
CELL_BOOLLoad cells whose value is bool
CELL_DATALoad cells data including values, formulas and formatting
CELL_ERRORLoad cells whose value is error
CELL_NUMERICLoad cells whose value is numeric(including datetime)
CELL_STRINGLoad cells whose value is string
CELL_VALUELoad cells value(all value types) only
CHARTLoad charts
CONDITIONAL_FORMATTINGLoad conditional formatting
DATA_VALIDATIONLoad data validations
DEFINED_NAMESLoad defined Name objects
DOCUMENT_PROPERTIESLoad document properties
DRAWINGDrawing objects(including Chart, Picture, OleObject and all other drawing objects)
FORMULALoad cell formulas.
HYPERLINKSLoad hyperlinks
MERGED_AREALoad merged cells
NONELoad nothing for sheet data
OLE_OBJECTLoad OleObjects
PICTURELoad pictures
PIVOT_TABLELoad pivot tables
REVISIONLoad revision logs
SETTINGSLoad settings for workbook and worksheet
SHAPELoad shapes
SHEET_DATALoad all data of worksheet, such as cells data, settings, objects, …etc.
SHEET_SETTINGSLoad settings for worksheet
STRUCTURELoad structure of the workbook
STYLELoad styles for cell formatting
TABLELoad tables
VBALoad VBA projects
XML_MAPLoad XmlMap

Methods

MethodDescription
equals(Object arg0)
getClass()
hashCode()
notify()
notifyAll()
toString()
wait()
wait(long arg0)
wait(long arg0, int arg1)

ALL

public static final int ALL

Load all

BOOK_SETTINGS

public static final int BOOK_SETTINGS

Load settings for workbook

CELL_BLANK

public static final int CELL_BLANK

Load cells whose value is blank

CELL_BOOL

public static final int CELL_BOOL

Load cells whose value is bool

CELL_DATA

public static final int CELL_DATA

Load cells data including values, formulas and formatting

CELL_ERROR

public static final int CELL_ERROR

Load cells whose value is error

CELL_NUMERIC

public static final int CELL_NUMERIC

Load cells whose value is numeric(including datetime)

CELL_STRING

public static final int CELL_STRING

Load cells whose value is string

CELL_VALUE

public static final int CELL_VALUE

Load cells value(all value types) only

CHART

public static final int CHART

Load charts

CONDITIONAL_FORMATTING

public static final int CONDITIONAL_FORMATTING

Load conditional formatting

DATA_VALIDATION

public static final int DATA_VALIDATION

Load data validations

DEFINED_NAMES

public static final int DEFINED_NAMES

Load defined Name objects

DOCUMENT_PROPERTIES

public static final int DOCUMENT_PROPERTIES

Load document properties

DRAWING

public static final int DRAWING

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

FORMULA

public static final int FORMULA

Load cell formulas.

Remarks

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 HYPERLINKS

Load hyperlinks

MERGED_AREA

public static final int MERGED_AREA

Load merged cells

NONE

public static final int NONE

Load nothing for sheet data

Remarks

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.

OLE_OBJECT

public static final int OLE_OBJECT

Load OleObjects

PICTURE

public static final int PICTURE

Load pictures

PIVOT_TABLE

public static final int PIVOT_TABLE

Load pivot tables

REVISION

public static final int REVISION

Load revision logs

SETTINGS

public static final int SETTINGS

Load settings for workbook and worksheet

SHAPE

public static final int SHAPE

Load shapes

Remarks

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.

SHEET_DATA

public static final int SHEET_DATA

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

SHEET_SETTINGS

public static final int SHEET_SETTINGS

Load settings for worksheet

STRUCTURE

public static final int STRUCTURE

Load structure of the workbook

STYLE

public static final int STYLE

Load styles for cell formatting

TABLE

public static final int TABLE

Load tables

VBA

public static final int VBA

Load VBA projects

XML_MAP

public static final int XML_MAP

Load XmlMap

equals(Object arg0)

public boolean equals(Object arg0)

Parameters:

ParameterTypeDescription
arg0java.lang.Object

Returns: boolean

getClass()

public final native Class<?> getClass()

Returns: java.lang.Class

hashCode()

public native int hashCode()

Returns: int

notify()

public final native void notify()

notifyAll()

public final native void notifyAll()

toString()

public String toString()

Returns: java.lang.String

wait()

public final void wait()

wait(long arg0)

public final native void wait(long arg0)

Parameters:

ParameterTypeDescription
arg0long

wait(long arg0, int arg1)

public final void wait(long arg0, int arg1)

Parameters:

ParameterTypeDescription
arg0long
arg1int