MarketplaceListingsCustom ActivityCalculated Pivot for Excel

Calculated Pivot for Excel

Bronze Certified

Custom Activity

1 reviews

468

Calculated Pivot for Excel

Bronze Certified

Custom Activity

1 reviews

468


Summary

Create a Pivot Table in Excel for Sum, Count or Average aggregation.

carouselImage0

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.

Benefits


Published: 12 Feb 2021 | Updated: 12 Feb 2021

Zohra Lanewala
Software Developer

License

3-Clause BSD


Code Language

Visual Basic


Runtime

.NET Framework


Tags

average
background
count
excel
pivot
sum

Compatibility

Compatible with all previous and current versions of UiPath Studio


Dependencies

Microsoft.Office.Interop.Excel (> = 15.0.0.0)



Similar Listings