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:
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 {‘A1’, ‘R1C1’}
- tagname = 'calcPr'
- class openpyxl.workbook.properties.FileVersion(appName=None, lastEdited=None, lowestEdited=None, rupBuild=None, codeName=None)[source]
Bases:
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:
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 {‘placeholders’, ‘all’}
- showPivotChartFilter
Values must be of type <class ‘bool’>
- tagname = 'workbookPr'
- updateLinks
Value must be one of {‘always’, ‘never’, ‘userSet’}