openpyxl.worksheet.errors module

class openpyxl.worksheet.errors.Extension(uri=None)

Bases: openpyxl.descriptors.serialisable.Serialisable

tagname = 'extension'

uri

Values must be of type <class ‘str’>

class openpyxl.worksheet.errors.ExtensionList(ext=())

Bases: openpyxl.descriptors.serialisable.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)

Bases: openpyxl.descriptors.serialisable.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 openpyxl.descriptors.excel.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)

Bases: openpyxl.descriptors.serialisable.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'