English
Summary
Create a Pivot Table in Excel for Sum, Count or Average aggregation.
Overview
- Filename (This activity works on only one file and it must contain your data source for pivot)
- Data Source Sheet & Range
- Destination Sheet & Cell (Sheet will be created if it does not already exist)
- PivotTable Value Field (Field from Data Source) & Formula (Sum, Count or Average)
- A boolean value for Successful
- An Exception object if occurred
Benefits
Published: 12 Feb 2021 | Updated: 12 Feb 2021
License
3-Clause BSD
Code Language
Visual Basic
Runtime
.NET Framework
Tags
Compatibility
Compatible with all previous and current versions of UiPath Studio
Dependencies
Microsoft.Office.Interop.Excel (> = 15.0.0.0)
Documentation
Support
UiPath Community SupportSimilar Listings
Excel Pivot Table Filter
By using this activity we can filter the pivot table in an Excel application
1.3k
Bronze Certified
Pivot Data Table Activity
Pivot transformation is very useful to summarize data in a flat data table (columns and rows), providing a more clean visualization of the data
2.5k
Bronze Certified
Calculate Sum of Colored Cells in Excel Sheet
Calculate the Sum of Excel colored cells in any given range
33
Bronze Certified
Create Password Protected Excel and Word Document
An activity pack used to create password protected Excel and Word documents
3 reviews
3.2k
Bronze Certified
