openpyxl.workbook.properties模块¶
- 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¶
值的类型必须小于class'bool'>
- calcId¶
值的类型必须小于class“int”>
- calcMode¶
Value must be one of {'autoNoTable', 'manual', 'auto'}
- calcOnSave¶
值的类型必须小于class'bool'>
- concurrentCalc¶
值的类型必须小于class'bool'>
- concurrentManualCount¶
值的类型必须小于class“int”>
- forceFullCalc¶
值的类型必须小于class'bool'>
- fullCalcOnLoad¶
值的类型必须小于class'bool'>
- fullPrecision¶
值的类型必须小于class'bool'>
- iterate¶
值的类型必须小于class'bool'>
- iterateCount¶
值的类型必须小于class“int”>
- iterateDelta¶
值的类型必须小于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)[源代码]¶
基类：
openpyxl.descriptors.serialisable.Serialisable- appName¶
值的类型必须小于class'str'>
- codeName¶
- lastEdited¶
值的类型必须小于class'str'>
- lowestEdited¶
值的类型必须小于class'str'>
- rupBuild¶
值的类型必须小于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¶
值的类型必须小于class'bool'>
- autoCompressPictures¶
值的类型必须小于class'bool'>
- backupFile¶
值的类型必须小于class'bool'>
- checkCompatibility¶
值的类型必须小于class'bool'>
- codeName¶
值的类型必须小于class'str'>
- date1904¶
值的类型必须小于class'bool'>
- dateCompatibility¶
值的类型必须小于class'bool'>
- defaultThemeVersion¶
值的类型必须小于class“int”>
- filterPrivacy¶
值的类型必须小于class'bool'>
- hidePivotFieldList¶
值的类型必须小于class'bool'>
- promptedSolutions¶
值的类型必须小于class'bool'>
- publishItems¶
值的类型必须小于class'bool'>
- refreshAllConnections¶
值的类型必须小于class'bool'>
- saveExternalLinkValues¶
值的类型必须小于class'bool'>
- showBorderUnselectedTables¶
值的类型必须小于class'bool'>
- showInkAnnotation¶
值的类型必须小于class'bool'>
- showObjects¶
值必须是“all”、“placeholders”之一
- showPivotChartFilter¶
值的类型必须小于class'bool'>
- tagname = 'workbookPr'¶
- updateLinks¶
Value must be one of {'always', 'never', 'userSet'}
