Refresh Pivot Table
AutomatR.Excel.Activities.RefreshPivotTable
The "Refresh Pivot Table" activity in AutomatR is part of the Excel activities package, designed to refresh a specified pivot table within a workbook. This activity ensures that the pivot table reflects the most up-to-date data, facilitating automation workflows involving dynamic Excel reports.
Properties
| Name | Description |
|---|---|
| Input | |
| Sheet Name | Enter the sheet name of the workbook where you want to refresh the pivot table. String variables containing the sheet name. |
| Table Name | Enter the name of the pivot table that you want to refresh. String variables containing the pivot table name. |
| Misc | |
| Display Name | The display name of the activity. A display name is automatically generated when you indicate a target. |
| Optional | |
| Delay | Enter the wait time in seconds (Example: 5 seconds i.e., 5) to start the activity. Integer variables containing the delay duration. |
How to use:
- Drag and drop the "Refresh Pivot Table" activity onto the workflow.
- Configure the properties by specifying the sheet name and the name of the pivot table to be refreshed.
- Optionally, configure the delay.
- Execute the workflow to refresh the specified pivot table within the Excel workbook.
Example: Consider an example where the "Refresh Pivot Table" activity is used to refresh a pivot table named "SalesPivotTable" on the sheet named "SalesData" in an Excel workbook:
Refresh Pivot Table:
Sheet Name: "SalesData"
Table Name: "SalesPivotTable"
In this example, the activity refreshes the "SalesPivotTable" on the "SalesData" sheet, ensuring that the pivot table reflects the most recent data.