Create Pivot table in different sheet of same excel

Hi All,

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

Thanks,
Riya

@Riya1 ,

yes its possible

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,

grafik

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.

@Rahul_Unnikrishnan
image

Still not present…:frowning:

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

1 Like

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

1 Like

Hi @Rahul_Unnikrishnan

image
Any idea about this error?

Thanks

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.

@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:

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.

@Riya1

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

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

@Rahul_Unnikrishnan ,

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

Thanks

@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.

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

Thanks

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

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

@Rahul_Unnikrishnan
image
I have different properties of this activity.

thanks

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

for your current project do as below.

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

@Rahul_Unnikrishnan
After doing this there is no activity as pivot