changes.mady.by.user Unknown User (ingridh)
Saved on Aug 10, 2012
changes.mady.by.user Alison Bird [softartisans]
...
ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsxlsx"); Worksheet ws = wb.Worksheets[0]; DataField df = ws.PivotTables[0].DataFields[0]; df.SummarizeBy = PivotTableField.SummarizeByType.Average;
Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsxlsx") Dim ws As Worksheet = wb.Worksheets(0) Dim df As DataField = ws.PivotTables(0).DataFields(0) df.SummarizeBy = PivotTableField.SummarizebyType.Average;