Create Pivot table in different sheet of same excel

Help Activities
1

Hi All,

Is there any way to create a excel sheet1 pivot table in sheet2 of same excel?

Thanks,
Riya

2

@Riya1 ,

yes its possible

3

Hi @Rahul_Unnikrishnan

UiPath.Excel.Activities.Business.CreatePivotTableX mentined package is not available in UiPath.
Can you pls guide from where I can install it?

Thanks,

4

grafik

5

Hello @Riya1 ,

Which version of uipath are you using? Also is it a modern designer?

Else go to Home->Setting->Design->use modern for new project. Then you will able to see.

For the current project, you go to project settings and enable modern design.

Then you will abel to see this.

6

@Rahul_Unnikrishnan
image

Still not present…:frowning:

7

@Riya1 Its there Riya… Create Pivot Table… Check in the screenshot :smiley:

1 Like
8

we do see create Pivot Table activity
maybe you can update the excel package to a newer version

1 Like
9

Hi @Rahul_Unnikrishnan

image
Any idea about this error?

Thanks

10

I think you are trying to create the pivot table on a sheet where some data is there. So if pivot extends to that data it will throw this error.

Try in a fresh sheet.

11

@Rahul_Unnikrishnan ,

Still getting same error.
Can you pls provide the sample xaml for creating a pivot table in diff sheet,if possible.

Thanks in adv :slightly_smiling_face:

12

Hi @Riya1 ,

If you do not want the Pivot to be a restricted to a Table in Excel. Could you maybe provide us with the Sample Input Data and the Expected Pivot Table Output for the Input ?

We might be able to perform Datatable Operations and Create the Pivoted Data.

13

@Riya1

You can create as below for creating pivot in separate sheet.

image
image596×729 21.5 KB

If you want to create in the same sheet, then you can choose Destination as below. N2 can be replaced with the cell number in which you want to create the pivot.

image

14

@Rahul_Unnikrishnan ,

Need to create pivot table by using some fields only.How can I achieve this?

Thanks

15

@Riya1 you can change the fields in the Create pivot activity. You need to choose only the relevant fields and select it as rows, column or value based on your need.

16

@Rahul_Unnikrishnan Can you pls share the sample xaml for choosing column and row in pivot table?

Thanks

17

@Riya1 you can create a process as i shared here.

in that image you can see how to choose row, column and value

18

@Rahul_Unnikrishnan
image
I have different properties of this activity.

thanks

19

@Riya1 plz switch to modern designer or do as below.

for your current project do as below.

image
image1194×904 70.6 KB

Home->Settings->Design->Use Modern for New Project (going forward for your new projects)

20

@Rahul_Unnikrishnan
After doing this there is no activity as pivot
image