changes.mady.by.user Alison Bird [softartisans]
Saved on Sep 27, 2012
...
ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.CreateOpen("template.xlsx"); ItemsToRetain items = wb[0].PivotTables[0].PivotTableSettings.ItemsToRetain;
Dim xla As New ExcelApplication() Dim wb As Workbook = xla.CreateOpen("template.xlsx") Dim palitems As ItemsToRetain = wb[(0]).PivotTables[(0]).PivotTableSettings.ItemsToRetain;