I want to refresh PivotTable.
I thought it was automatic so i have do that :
- Code: Select all
var workbook = new Workbook();
workbook.LoadFromFile(Path + "Sample.xlsx");
var ws = workbook.Worksheets[0];
ws.Range["B4"].Value = "1";
workbook.SaveToFile(Chemin + "Sample - Out.xlsx", ExcelVersion.Version2016);
But PivotTable is not refresh :
So i have try this :
- Code: Select all
var workbook = new Workbook();
workbook.LoadFromFile(Chemin + "Sample.xlsx");
var ws = workbook.Worksheets[0];
ws.Range["B4"].Value = "1";
// https://www.e-iceblue.com/forum/how-to-refresh-pivot-table-t5062-15.html
XlsPivotTable pt = workbook.Worksheets[0].PivotTables["TCD"] as XlsPivotTable;
pt.Cache.IsRefreshOnLoad = true;
workbook.SaveToFile(Chemin + "Sample - Out.xlsx", ExcelVersion.Version2016);
but in output, Source data of PivotTable have change :
Do you know how can i refresh a PivotTable ?
Thanks