Skip to main content

Метод PivotTable.getColumnFields

Метод возвращает список полей PivotTableCategoryField``из области колонок.

Пример​


 columnFields = pivotTable.getColumnFields()
 columnFieldsEnumerator = columnFields.getEnumerator()
 for pivotTableCategoryField in columnFieldsEnumerator:
  print(pivotTableCategoryField.fieldProperties.fieldAlias)
  print(pivotTableCategoryField.fieldProperties.subtotalAlias)
  print(pivotTableCategoryField.fieldProperties.fieldName)
  subtotalFunctions = pivotTableCategoryField.subtotalFunctions
  print(subtotalFunctions.Count)