aspose.cells

Field Detail

• NONE

  const Number 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 Number ALL

  Load all

• CELL_BLANK

  const Number CELL_BLANK

  Load cells whose value is blank

• CELL_STRING

  const Number CELL_STRING

  Load cells whose value is string

• CELL_NUMERIC

  const Number CELL_NUMERIC

  Load cells whose value is numeric(including datetime)

• CELL_ERROR

  const Number CELL_ERROR

  Load cells whose value is error

• CELL_BOOL

  const Number CELL_BOOL

  Load cells whose value is bool

• CELL_VALUE

  const Number CELL_VALUE

  Load cells value(all value types) only

• FORMULA

  const Number 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 Number CELL_DATA

  Load cells data including values, formulas and formatting

• CHART

  const Number CHART

  Load charts

• SHAPE

  const Number 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 Number DRAWING

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

• MERGED_AREA

  const Number MERGED_AREA

  Load merged cells

• CONDITIONAL_FORMATTING

  const Number CONDITIONAL_FORMATTING

  Load conditional formatting

• DATA_VALIDATION

  const Number DATA_VALIDATION

  Load data validations

• PIVOT_TABLE

  const Number PIVOT_TABLE

  Load pivot tables

• TABLE

  const Number TABLE

  Load tables

• HYPERLINKS

  const Number HYPERLINKS

  Load hyperlinks

• SHEET_SETTINGS

  const Number SHEET_SETTINGS

  Load settings for worksheet

• SHEET_DATA

  const Number SHEET_DATA

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

• BOOK_SETTINGS

  const Number BOOK_SETTINGS

  Load settings for workbook

• SETTINGS

  const Number SETTINGS

  Load settings for workbook and worksheet

• XML_MAP

  const Number XML_MAP

  Load XmlMap

• STRUCTURE

  const Number STRUCTURE

  Load structure of the workbook

• DOCUMENT_PROPERTIES

  const Number DOCUMENT_PROPERTIES

  Load document properties

• DEFINED_NAMES

  const Number DEFINED_NAMES

  Load defined Name objects

• VBA

  const Number VBA

  Load VBA projects

• STYLE

  const Number STYLE

  Load styles for cell formatting

• PICTURE

  const Number PICTURE

  Load pictures

• OLE_OBJECT

  const Number OLE_OBJECT

  Load OleObjects

• REVISION

  const Number REVISION

  Load revision logs