asposecells.api
Class LoadDataFilterOptions

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

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

Field Detail

NONE

const 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

const int ALL
Load all

CELL_BLANK

const int CELL_BLANK
Load cells whose value is blank

CELL_STRING

const int CELL_STRING
Load cells whose value is string

CELL_NUMERIC

const int CELL_NUMERIC
Load cells whose value is numeric(including datetime)

CELL_ERROR

const int CELL_ERROR
Load cells whose value is error

CELL_BOOL

const int CELL_BOOL
Load cells whose value is bool

CELL_VALUE

const int CELL_VALUE
Load cells value(all value types) only

FORMULA

const 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

const int CELL_DATA
Load cells data including values, formulas and formattings

CHART

const int CHART
Load charts

SHAPE

const 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

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

MERGED_AREA

const int MERGED_AREA
Load merged cells

CONDITIONAL_FORMATTING

const int CONDITIONAL_FORMATTING
Load conditional formattings

DATA_VALIDATION

const int DATA_VALIDATION
Load data validations

PIVOT_TABLE

const int PIVOT_TABLE
Load pivot tables

TABLE

const int TABLE
Load tables

HYPERLINKS

const int HYPERLINKS
Load hyperlinks

SHEET_SETTINGS

const int SHEET_SETTINGS
Load settings for worksheet

SHEET_DATA

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

BOOK_SETTINGS

const int BOOK_SETTINGS
Load settings for workbook

SETTINGS

const int SETTINGS
Load settings for workbook and worksheet

XML_MAP

const int XML_MAP
Load XmlMap

STRUCTURE

const int STRUCTURE
Load structure of the workbook

DOCUMENT_PROPERTIES

const int DOCUMENT_PROPERTIES
Load document properties

DEFINED_NAMES

const int DEFINED_NAMES
Load defined Name objects

VBA

const int VBA
Load VBA projects

STYLE

const int STYLE
Load styles for cell formatting

PICTURE

const int PICTURE
Load pictures

OLE_OBJECT

const int OLE_OBJECT
Load OleObjects

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.