Пример #1
0
 private static void RefreshPivotTable(Excel.Worksheet workSheet, string pivotTableName, string pivotFormula)
 {
     PivotTable pivot = (PivotTable)workSheet.PivotTables(pivotTableName);
     pivot.SourceData = pivotFormula;
     pivot.RefreshTable();
 }