Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

Sets or returns the type of calculation used to summarize a data field. The available types are determined by PivotTableField.SummarizeByType.

Signature
C#
C#
 public SummarizeByType SummarizeBy{ get; set; }

...

Example
Code Block
csharp
csharp
titleC#

          ExcelApplication xla = new ExcelApplication();
          Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx");
          Worksheet ws = wb.Worksheets[0];
          DataField df = ws.PivotTables[0].DataFields[0];
          df.SummarizeBy = PivotTableField.SummarizeByType.Average;
        
Code Block
vbnet
vbnet
titlevb.net

          Dim xla As New ExcelApplication()
          Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsx")
          Dim ws As Worksheet = wb.Worksheets(0)
          Dim df As DataField = ws.PivotTables(0).DataFields(0)
          df.SummarizeBy = PivotTableField.SummarizebyType.Average
        
Remarks

DataFields Data fields are set to Count 'count' for string values and Sum 'sum' for numerical values by default.

This property cannot be set on CalculatedFields calculated fields and such fields will return SummarizeByType.Sum by default. You can check if a PivotField is calculated field with the IsCacluatedField Propertyproperty