PivotTable.RefreshData

RefreshData()

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

public PivotRefreshState 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

• enum PivotRefreshState
• 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 PivotRefreshState RefreshData(PivotTableRefreshOption option)

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

See Also

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