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