Skip to main content

Метод PivotTable.getColumnFields

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

Пример​


 PivotTableCategoryFields columnFields = pivotTable.getColumnFields();
 PivotTableCategoryFields.PivotTableCategoryFieldsEnumerator enumerator = columnFields.GetEnumerator();
 while (enumerator.MoveNext())
 {
    PivotTableCategoryField pivotTableCategoryField = enumerator.Current;
    Console.WriteLine(pivotTableCategoryField.fieldProperties.fieldAlias);
    Console.WriteLine(pivotTableCategoryField.fieldProperties.subtotalAlias);
    Console.WriteLine(pivotTableCategoryField.fieldProperties.fieldName);
    PivotTableFunctions subtotalFunctions = pivotTableCategoryField.subtotalFunctions;
    Console.WriteLine(subtotalFunctions.Count);
 }