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,270 points
1,092 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 8, 2018 by findingbugs
• 3,180 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 25 by Anvi
• 13,960 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
966 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
1,625 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 in RPA by Shivi Singhal
3,721 views
0 votes
1 answer

Creating multiple sheets in excel workbook using UiPath

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

answered Mar 4 in RPA by Abha
• 27,180 points
1,139 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
371 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,115 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
591 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
• 56,940 points
526 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 in RPA by Anvi
• 13,960 points
5,954 views
0 votes
1 answer

How to open chrome in Incognito Mode using UiPath?

Hey @Smita, if you want to open ...READ MORE

answered Mar 8 in RPA by Anvi
• 13,960 points
217 views