Business Solutions
Business Solutions
Collections
Collections
Business Solutions
Business Solutions
Collections
Collections
English
|
Japanese
Calculated Pivot for Excel
by Zohra Lanewala
1
802
Calculated Pivot for Excel
by Zohra Lanewala
1
Custom Activity
802
Overview
Overview
This activity can help in quickly creating a Pivot Table for the simple needs of Excel users.
It takes the following as input:
- 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)
And gives the following as output:
- A boolean value for Successful
- An Exception object if occurred
Before using the activity, the Excel file should be closed.
The activity will load the file and process the activity in the background.
Excel file name must be mentioned in Absolute Path.
Features
Features
Additional Information
Additional Information
Dependencies
Code Language
C#, Visual Basic
Runtime
Windows Legacy (.Net Framework 4.6.1)
License
BSD
Technical
Version
1.0.0Updated
02 Feb 2021Works with
Compatible with all previous and current versions of UiPath Studio
Certification
Silver Certified
Tags
average
background
count
excel
pivot
sum
Support
UiPath Community Support
Resources
Similar Listings
English
English
日本語