Field Summary | ||
---|---|---|
const Number | NONE | |
Load nothing for sheet data | ||
const Number | ALL | |
Load all | ||
const Number | CELL_BLANK | |
Load cells whose value is blank | ||
const Number | CELL_STRING | |
Load cells whose value is string | ||
const Number | CELL_NUMERIC | |
Load cells whose value is numeric(including datetime) | ||
const Number | CELL_ERROR | |
Load cells whose value is error | ||
const Number | CELL_BOOL | |
Load cells whose value is bool | ||
const Number | CELL_VALUE | |
Load cells value(all value types) only | ||
const Number | FORMULA | |
Load cell formulas. | ||
const Number | CELL_DATA | |
Load cells data including values, formulas and formattings | ||
const Number | CHART | |
Load charts | ||
const Number | SHAPE | |
Load shapes | ||
const Number | DRAWING | |
Drawing objects(including Chart, Picture, OleObject and all other drawing objects) | ||
const Number | MERGED_AREA | |
Load merged cells | ||
const Number | CONDITIONAL_FORMATTING | |
Load conditional formattings | ||
const Number | DATA_VALIDATION | |
Load data validations | ||
const Number | PIVOT_TABLE | |
Load pivot tables | ||
const Number | TABLE | |
Load tables | ||
const Number | HYPERLINKS | |
Load hyperlinks | ||
const Number | SHEET_SETTINGS | |
Load settings for worksheet | ||
const Number | SHEET_DATA | |
Load all data of worksheet, such as cells dadta, settings, objects, ...etc. | ||
const Number | BOOK_SETTINGS | |
Load settings for workbook | ||
const Number | SETTINGS | |
Load settings for workbook and worksheet | ||
const Number | XML_MAP | |
Load XmlMap | ||
const Number | STRUCTURE | |
Load structure of the workbook | ||
const Number | DOCUMENT_PROPERTIES | |
Load document properties | ||
const Number | DEFINED_NAMES | |
Load defined Name objects | ||
const Number | VBA | |
Load VBA projects | ||
const Number | STYLE | |
Load styles for cell formatting | ||
const Number | PICTURE | |
Load pictures | ||
const Number | OLE_OBJECT | |
Load OleObjects |
Field Detail |
---|
NONE | |
const Number NONE |
ALL | |
const Number ALL |
CELL_BLANK | |
const Number CELL_BLANK |
CELL_STRING | |
const Number CELL_STRING |
CELL_NUMERIC | |
const Number CELL_NUMERIC |
CELL_ERROR | |
const Number CELL_ERROR |
CELL_BOOL | |
const Number CELL_BOOL |
CELL_VALUE | |
const Number CELL_VALUE |
FORMULA | |
const Number FORMULA |
CELL_DATA | |
const Number CELL_DATA |
CHART | |
const Number CHART |
SHAPE | |
const Number SHAPE |
DRAWING | |
const Number DRAWING |
MERGED_AREA | |
const Number MERGED_AREA |
CONDITIONAL_FORMATTING | |
const Number CONDITIONAL_FORMATTING |
DATA_VALIDATION | |
const Number DATA_VALIDATION |
PIVOT_TABLE | |
const Number PIVOT_TABLE |
TABLE | |
const Number TABLE |
HYPERLINKS | |
const Number HYPERLINKS |
SHEET_SETTINGS | |
const Number SHEET_SETTINGS |
SHEET_DATA | |
const Number SHEET_DATA |
BOOK_SETTINGS | |
const Number BOOK_SETTINGS |
SETTINGS | |
const Number SETTINGS |
XML_MAP | |
const Number XML_MAP |
STRUCTURE | |
const Number STRUCTURE |
DOCUMENT_PROPERTIES | |
const Number DOCUMENT_PROPERTIES |
DEFINED_NAMES | |
const Number DEFINED_NAMES |
VBA | |
const Number VBA |
STYLE | |
const Number STYLE |
PICTURE | |
const Number PICTURE |
OLE_OBJECT | |
const Number OLE_OBJECT |