openpyxl.worksheet.errors module

class openpyxl.worksheet.errors.Extension(uri=None)[source]

Bases: Serialisable

tagname = 'extension'
uri

Values must be of type <class ‘str’>

class openpyxl.worksheet.errors.ExtensionList(ext=())[source]

Bases: Serialisable

ext

A sequence (list or tuple) that may only contain objects of the declared type

tagname = 'extensionList'
class openpyxl.worksheet.errors.IgnoredError(sqref=None, evalError=False, twoDigitTextYear=False, numberStoredAsText=False, formula=False, formulaRange=False, unlockedFormula=False, emptyCellReference=False, listDataValidation=False, calculatedColumn=False)[source]

Bases: Serialisable

calculatedColumn

Values must be of type <class ‘bool’>

emptyCellReference

Values must be of type <class ‘bool’>

evalError

Values must be of type <class ‘bool’>

formula

Values must be of type <class ‘bool’>

formulaRange

Values must be of type <class ‘bool’>

listDataValidation

Values must be of type <class ‘bool’>

numberStoredAsText

Values must be of type <class ‘bool’>

sqref

alias of CellRange

tagname = 'ignoredError'
twoDigitTextYear

Values must be of type <class ‘bool’>

unlockedFormula

Values must be of type <class ‘bool’>

class openpyxl.worksheet.errors.IgnoredErrors(ignoredError=(), extLst=None)[source]

Bases: Serialisable

extLst

Values must be of type <class ‘openpyxl.worksheet.errors.ExtensionList’>

ignoredError

A sequence (list or tuple) that may only contain objects of the declared type

tagname = 'ignoredErrors'