Create Pivot Table in Excel

[grknkp (gurkankapili)]

Hi,
I’m trying to create a pivot table. I want to add columns A and B to rows, column C to column and column d to values. Can you help me please?

Regards

[HareeshMR (Hareesh Madasi)]

Please check this topic @grknkp

Create pivot table with dynamic data source range in uipath

Here it is @mashy2, May be it is bit clumpsy, try to understand Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook Dim ws As Microsoft.Office.Interop.Excel.Worksheet excel = New Microsoft.Office.Interop.Excel.Application 'create the instance of excel work book' Dim p_ws As Microsoft.Office.Interop.Excel.Worksheet Dim rng As Microsoft.Office.Interop.Excel.Range 'capturing the range of qry_GS_Monthly_ProjRes ''…

[monika.c (Monika Chaudhari)]

@grknkp
You can record macro in excel and use that script in invoke vba activity to create pivot table.

[grknkp (gurkankapili)]

Thanks @monika.c It’s working.