Skip to main content

Метод PivotTable.getRowFields

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

Пример​


 PivotTableCategoryFields rowFields = pivotTable.getRowFields();
 PivotTableCategoryFields.PivotTableCategoryFieldsEnumerator enumerator = rowFields.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);
 }