Pivot table in excel using UIpath

0 votes
Hi I am planning to make a pivot table using UIpath.

Is there a way to make a pivot using UIpath? anyone have experienced on this? what function to use?
May 28, 2018 in RPA by Atul
• 5,530 points
1,045 views
Yes I know how to make pivot table in ui path
Hey can you please show some steps or any example how that can be done?

1 answer to this question.

0 votes

I'd suggest you are going to have to create an empty Excel workbook first and then add a VBA macro to it that will create a pivot table.

You can then use UIPath to pull in the raw data into the workbook and execute the macro to actually create the pivot table.

answered May 28, 2018 by wrecker
• 3,110 points

Related Questions In RPA

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
4,139 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, 2019 in RPA by Abha
• 27,720 points
1,362 views
0 votes
1 answer

How to extract table and text from pdf file and load into Excel by using workbench commands in automation anywhere

Hey Dhruv, to extract table and text ...READ MORE

answered Oct 10, 2019 in RPA by Abha
• 27,720 points
561 views
0 votes
2 answers

change a specific column of an excel sheet in UiPath

1. First of all , you need ...READ MORE

answered May 16, 2019 in RPA by Venkat
• 320 points
3,079 views
0 votes
1 answer

UiPath - Citirx Automation

best way to do that is to ...READ MORE

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

UiPath - Web Scraping

Multiple solutions are listed below: Check your Selector Use ...READ MORE

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

Robot Manager in UiPath

the robot.exe file is located in: C:\Users\USER_ACCOUNT\AppData\Local\UiPath\app-17.1.6523\Ui-Robot.exe Hope it ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,110 points
518 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
431 views
0 votes
4 answers

Pivot table in excel using UIpath

You can use Create Pivot Table activity ...READ MORE

answered Feb 25, 2019 in RPA by Anvi
• 14,010 points
1,235 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,717 views