Excel automation based on specific condition

[Shubham_Varshney]

We can use macro’s to attend that out

For reference
Creating Pivot Table in the background - #3 by samir

and

Create a pivot table

@sshitol , There are two ways to create a pivot table in UiPath… Make the data in your excel in a tabular form and give the name to the table. Use pivot table activity and provide that name and sheet in that so that it will form the entire data to pivot. or You need to write a piece of code to make the data into pivot. Here is the code to copy two rows of data into new sheet and making a pivot of that data Dim excel As Microsoft.Office.Interop.Excel.Application Dim w…