asposecells.api

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 formatting

• CHART

  const int CHART

  Load charts

• SHAPE

  const 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.

• 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 formatting

• 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 data, 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

• REVISION

  const int REVISION

  Load revision logs