openpyxl.workbook.properties module¶

class openpyxl.workbook.properties.CalcProperties(calcId=124519, calcMode=None, fullCalcOnLoad=True, refMode=None, iterate=None, iterateCount=None, iterateDelta=None, fullPrecision=None, calcCompleted=None, calcOnSave=None, concurrentCalc=None, concurrentManualCount=None, forceFullCalc=None)[source]¶

Bases: openpyxl.descriptors.serialisable.Serialisable

calcCompleted¶: Values must be of type <class ‘bool’>

calcId¶: Values must be of type <class ‘int’>

calcMode¶: Value must be one of {‘manual’, ‘auto’, ‘autoNoTable’}

calcOnSave¶: Values must be of type <class ‘bool’>

concurrentCalc¶: Values must be of type <class ‘bool’>

concurrentManualCount¶: Values must be of type <class ‘int’>

forceFullCalc¶: Values must be of type <class ‘bool’>

fullCalcOnLoad¶: Values must be of type <class ‘bool’>

fullPrecision¶: Values must be of type <class ‘bool’>

iterate¶: Values must be of type <class ‘bool’>

iterateCount¶: Values must be of type <class ‘int’>

iterateDelta¶: Values must be of type <class ‘float’>

refMode¶: Value must be one of {‘R1C1’, ‘A1’}

tagname = 'calcPr'¶

class openpyxl.workbook.properties.FileVersion(appName=None, lastEdited=None, lowestEdited=None, rupBuild=None, codeName=None)[source]¶

Bases: openpyxl.descriptors.serialisable.Serialisable

appName¶: Values must be of type <class ‘str’>

codeName¶

lastEdited¶: Values must be of type <class ‘str’>

lowestEdited¶: Values must be of type <class ‘str’>

rupBuild¶: Values must be of type <class ‘str’>

tagname = 'fileVersion'¶

class openpyxl.workbook.properties.WorkbookProperties(date1904=None, dateCompatibility=None, showObjects=None, showBorderUnselectedTables=None, filterPrivacy=None, promptedSolutions=None, showInkAnnotation=None, backupFile=None, saveExternalLinkValues=None, updateLinks=None, codeName=None, hidePivotFieldList=None, showPivotChartFilter=None, allowRefreshQuery=None, publishItems=None, checkCompatibility=None, autoCompressPictures=None, refreshAllConnections=None, defaultThemeVersion=None)[source]¶

Bases: openpyxl.descriptors.serialisable.Serialisable

allowRefreshQuery¶: Values must be of type <class ‘bool’>

autoCompressPictures¶: Values must be of type <class ‘bool’>

backupFile¶: Values must be of type <class ‘bool’>

checkCompatibility¶: Values must be of type <class ‘bool’>

codeName¶: Values must be of type <class ‘str’>

date1904¶: Values must be of type <class ‘bool’>

dateCompatibility¶: Values must be of type <class ‘bool’>

defaultThemeVersion¶: Values must be of type <class ‘int’>

filterPrivacy¶: Values must be of type <class ‘bool’>

hidePivotFieldList¶: Values must be of type <class ‘bool’>

promptedSolutions¶: Values must be of type <class ‘bool’>

publishItems¶: Values must be of type <class ‘bool’>

refreshAllConnections¶: Values must be of type <class ‘bool’>

saveExternalLinkValues¶: Values must be of type <class ‘bool’>

showBorderUnselectedTables¶: Values must be of type <class ‘bool’>

showInkAnnotation¶: Values must be of type <class ‘bool’>

showObjects¶: Value must be one of {‘all’, ‘placeholders’}

showPivotChartFilter¶: Values must be of type <class ‘bool’>

tagname = 'workbookPr'¶

updateLinks¶: Value must be one of {‘never’, ‘always’, ‘userSet’}