openpyxl.cell.cell

Manage individual cells in a spreadsheet.

The Cell class is required to know its value and type, display options, and any other features of an Excel cell. Utilities for referencing cells using Excel's 'A1' column/row nomenclature are also provided.

ERROR_CODES

attributeERROR_CODES

= ('#NULL!', '#DIV/0!', '#VALUE!', '#REF!', '#NAME?', '#NUM!', '#N/A')

ILLEGAL_CHARACTERS_RE

attributeILLEGAL_CHARACTERS_RE

= re.compile('[\\000-\\010]|[\\013-\\014]|[\\016-\\037]')

KNOWN_TYPES

attributeKNOWN_TYPES

= NUMERIC_TYPES + TIME_TYPES + STRING_TYPES + (bool, type(None))

STRING_TYPES

attributeSTRING_TYPES

= (str, bytes, CellRichText)

TIME_FORMATS

attributeTIME_FORMATS

= {datetime.datetime: numbers.FORMAT_DATE_DATETIME, datetime.date: numbers.FORMAT_DATE_YYYYMMDD2, datetime.time: numbers.FORMAT_DATE_TIME6, datetime.timedelta: numbers.FORMAT_DATE_TIMEDELTA}

TIME_TYPES

attributeTIME_TYPES

= (datetime.datetime, datetime.date, datetime.time, datetime.timedelta)

TYPE_BOOL

attributeTYPE_BOOL

= 'b'

TYPE_ERROR

attributeTYPE_ERROR

= 'e'

TYPE_FORMULA

attributeTYPE_FORMULA

= 'f'

TYPE_FORMULA_CACHE_STRING

attributeTYPE_FORMULA_CACHE_STRING

= 'str'

TYPE_INLINE

attributeTYPE_INLINE

= 'inlineStr'

TYPE_NULL

attributeTYPE_NULL

= 'n'

TYPE_NUMERIC

attributeTYPE_NUMERIC

= 'n'

TYPE_STRING

attributeTYPE_STRING

= 's'

VALID_TYPES

attributeVALID_TYPES

= (TYPE_STRING, TYPE_FORMULA, TYPE_NUMERIC, TYPE_BOOL, TYPE_NULL, TYPE_INLINE, TYPE_ERROR, TYPE_FORMULA_CACHE_STRING)