How to Create Pivot table in Uipath | RPA Uipath

The Excel activities package aids users to automate all aspects of Microsoft Excel, as we know it is an application intensely used by many in all types of businesses.

It contains activities that enable you to read information from a cell, columns, rows or ranges, write to other spreadsheets or workbooks, execute macros, and even extract formulas. You can also sort data, color code it or append additional information.

The activities grouped under the System chapter can be executed even if Microsoft Excel is not installed on the machine, whereas the ones under the App Integration chapter require the app on the machine on which they run.

All the activities in the latter category have to be included in Excel Application Scope to work, apart from the CSV ones.

Dedicated activities enable you to work with .csv files, while all the others work with .xlsx and .xls. The ones that only work with Excel Application Scope can also work with .xslm files.

By using this activities explained about how to create a pivot table.

Who can watch this session?
Those who are looking for answer of below question will best suite:

how to create pivot table in uipath?
how to create pivot table in excel uipath?
how to use create pivot table in uipath?
how to create pivot table in excel using uipath?
how to use create pivot table activity in uipath?
how to create a pivot table in uipath?
how to create pivot table using uipath?
**************************************************************
Did you enjoy the video? If so, give it a like above!

Subscribe to our channel for more techie video

Keep Learning!! Keep Growing!!

P.S. Make sure to keep up with us by clicking the bell!

[vishnu_addagada]

Nice one Deepak. But once the robot created a pivot table manually we need to select the columns or rows by opening excel file. Can we define in the activity it self that use these Headers as Rows and Columns like that?

[mohanaselvishanmugam]

Hi.. How can we define the rows and columns... please help..

[mohanbabusankar]

bro, in this video you used the "Refresh Pivot Table" know. In UiPath, Where and How the Refresh Pivot Table is worked?