Pivot table in excel using UIpath

0 votes
Heelo how to make a pivot table using UIpath?

Is there a way to make a pivot using UIpath?

please help
May 14, 2018 in RPA by Vardy
• 2,360 points
3,843 views

4 answers to this question.

0 votes

You can do it in two ways :

  1. Macro. Record macro and use "Execute macro" activity in the uipath

  2. UI Automation

answered May 14, 2018 by wrecker
• 3,110 points
0 votes
using create pivote table activity.
answered Nov 8, 2018 by srikanth neela
0 votes
Using UI Automation you can create pivot by
selecting the data to make pivot using 'select range' activity. Then using send hotkey, pass Alt+N+V+T (Will open the pivot dialog box) Now, select the row,column etc again by using find element or find image and drag and drop to required fields.
The Drag and drop can be done by using a combination of'click up' and 'click down' property in click activity.
Hope this helps
answered Nov 9, 2018 by findingbugs
• 3,260 points
+1 vote
You can use Create Pivot Table activity to create pivot table from any excel sheet. You just have to mention the source table name and the range where you want the pivot table to be created.
answered Feb 26, 2019 by Anvi
• 14,170 points

Related Questions In RPA

0 votes
1 answer

Pivot table in excel using UIpath

down vo I'd suggest you are going to ...READ MORE

answered May 28, 2018 in RPA by wrecker
• 3,110 points
2,008 views
0 votes
1 answer

Add filter to excel table in UiPath

If you use *my value as the ...READ MORE

answered May 16, 2018 in RPA by wrecker
• 3,110 points
2,354 views
0 votes
4 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

These are the steps to add two ...READ MORE

answered Aug 2, 2019 in RPA by Shivi Singhal
11,344 views
0 votes
1 answer

Creating multiple sheets in excel workbook using UiPath

Hi @Ashmita, you can create multiple excel ...READ MORE

answered Mar 5, 2019 in RPA by Abha
• 28,120 points
5,761 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
993 views
0 votes
1 answer

UiPath vs Workfusion

in WorkFusion, you can create a script ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
1,836 views
0 votes
1 answer

Surface automation in rpa?

Surface automation is a visual automation that is done using ...READ MORE

answered Apr 20, 2018 in RPA by wrecker
• 3,110 points
1,200 views
+1 vote
2 answers

Azure Cognitive services with RPA

Automation anywhere has support for making SOAP ...READ MORE

answered Aug 7, 2018 in RPA by Priyaj
• 58,080 points
895 views
+3 votes
1 answer

How to extract data from a website and save it to excel using UiPath?

Hi Piyush, if you want to extract ...READ MORE

answered Mar 8, 2019 in RPA by Anvi
• 14,170 points
19,190 views
0 votes
2 answers

How to open chrome in Incognito Mode using UiPath?

You need to select checkbox of Private ...READ MORE

answered Apr 11, 2020 in RPA by Manna Kaur
2,926 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP