LoadDataFilterOptions
Inheritance: java.lang.Object
public final class LoadDataFilterOptions
Represents the options to filter data when loading workbook from template.
Fields
Field | Description |
---|---|
ALL | Load all |
BOOK_SETTINGS | Load settings for workbook |
CELL_BLANK | Load cells whose value is blank |
CELL_BOOL | Load cells whose value is bool |
CELL_DATA | Load cells data including values, formulas and formatting |
CELL_ERROR | Load cells whose value is error |
CELL_NUMERIC | Load cells whose value is numeric(including datetime) |
CELL_STRING | Load cells whose value is string |
CELL_VALUE | Load cells value(all value types) only |
CHART | Load charts |
CONDITIONAL_FORMATTING | Load conditional formatting |
DATA_VALIDATION | Load data validations |
DEFINED_NAMES | Load defined Name objects |
DOCUMENT_PROPERTIES | Load document properties |
DRAWING | Drawing objects(including Chart, Picture, OleObject and all other drawing objects) |
FORMULA | Load cell formulas. |
HYPERLINKS | Load hyperlinks |
MERGED_AREA | Load merged cells |
NONE | Load nothing for sheet data |
OLE_OBJECT | Load OleObjects |
PICTURE | Load pictures |
PIVOT_TABLE | Load pivot tables |
REVISION | Load revision logs |
SETTINGS | Load settings for workbook and worksheet |
SHAPE | Load shapes |
SHEET_DATA | Load all data of worksheet, such as cells data, settings, objects, …etc. |
SHEET_SETTINGS | Load settings for worksheet |
STRUCTURE | Load structure of the workbook |
STYLE | Load styles for cell formatting |
TABLE | Load tables |
VBA | Load VBA projects |
XML_MAP | Load XmlMap |
Methods
Method | Description |
---|---|
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.
HYPERLINKS
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:
Parameter | Type | Description |
---|---|---|
arg0 | java.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:
Parameter | Type | Description |
---|---|---|
arg0 | long |
wait(long arg0, int arg1)
public final void wait(long arg0, int arg1)
Parameters:
Parameter | Type | Description |
---|---|---|
arg0 | long | |
arg1 | int |