Can somebody please help me to get the pivot table workflow created for the attached file. Input is sheet1 and output should be like sheet2 File.XLSX (89.3 KB)

Hi @Onkar_Nath_Sharma You can use Create Pivot Table Activity

i can use but how…that’s my query. If you can attach the screenshot of the activity or attach an XAML file, it would be better.

@Onkar_Nath_Sharma Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook Dim ws As Microsoft.Office.Interop.Excel.Worksheet Dim p_ws As Microsoft.Office.Interop.Excel.Worksheet Dim rng As Microsoft.Office.Interop.Excel.Range ‘capturing the ran…

HI, Do you have any idea how to make range dynamic? rng=ws.Range(“A8”,“F510”)‘Selects the given range of sheet 1’

Hello anyone? Can you pls answer above question i also have same query?

Hello @chandrashekar_padmin , @Onkar_Nath_Sharma Guys, just go through below thread, this help you. :slight_smile: [image] Creating Pivot Table in the background Help Hi @Michael_de_Borja I’ll suggest you to record macro in excel with creating Pivot table and use Invoke V…

Hello @samir , I have tried it , but still the same issue it is taking only particular , if data is dynamic it is considering the same. Please let me know

Hi @chandrashekar_padmin , have you resolved your concern? if yes, please share inputs because i am also having same concern.

Hello @VAYILA_RAMESH , Yes issue was solved but used a code in uipath. Thanks, Padmini

Hi Team I have used the above VB Code to create a pivot table but I was facing getting an error while running the code. Please refer below error message. Source: Excel Pivot Table Message: Exception has been thrown by the target of an invocation. Exception Type: System.Reflection.TargetInvocatio…

Pivot Table Creation

Learning Hub Academy Feedback

samir (Samir Mohite) July 30, 2019, 2:34pm 7

Hello @chandrashekar_padmin, @Onkar_Nath_Sharma

Guys, just go through below thread, this help you.

Topic		Replies	Views
Create Pivot Table in Excel Help excel , uiautomation , activities , error	3	1234	September 27, 2019
Create pivot table with dynamic data source range in uipath Help	4	4245	July 8, 2019
Create Pivot table using UIPATH Help excel , activities	42	16016	May 25, 2021
Create a pivot table Help	9	6152	August 20, 2020
Create table for pivot Studio studio , question , activities_panel	2	662	June 11, 2022

Pivot Table Creation

Related topics