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

值必须是“自动”、“手动”、“自动”之一

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 {'A1', 'R1C1'}

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

Value must be one of {'placeholders', 'all'}

showPivotChartFilter

值的类型必须小于class'bool'>

tagname = 'workbookPr'

Value must be one of {'always', 'userSet', 'never'}