# 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)

  Bases: `Serialisable`

  calcCompleted

    Values must be of type <class ‘bool’>

  calcId

    Values must be of type <class ‘int’>

  calcMode

    Value must be one of [‘auto’, ‘autoNoTable’, ‘manual’]

  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)

  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)

  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 [‘all’, ‘placeholders’]

  showPivotChartFilter

    Values must be of type <class ‘bool’>

  tagname = 'workbookPr'
  updateLinks

    Value must be one of [‘always’, ‘never’, ‘userSet’]