PivotTable.RefreshData

RefreshData()

Refreshes pivottable’s data and setting from it’s data source.

public void RefreshData()

Remarks

We will gather data from data source to a pivot cache ,then calculate the data in the cache to the cells. This method is only used to gather all data to a pivot cache.

See Also

• class PivotTable
• namespace Aspose.Cells.Pivot
• assembly Aspose.Cells

---

RefreshData(PivotTableRefreshOption)

Refreshes pivottable’s data and setting from it’s data source with options.

public void RefreshData(PivotTableRefreshOption option)

Parameter	Type	Description
option	PivotTableRefreshOption	The options for refreshing data source of pivot table.

See Also

• class PivotTableRefreshOption
• class PivotTable
• namespace Aspose.Cells.Pivot
• assembly Aspose.Cells