Create a pivot table in excel for a specified column in uipath

[Piraisoodan_J]

Hi ,

Excel automation,

I tried using create pivot table activity, i could not able to create a pivot table for a specific column. Is there any other way to succeed this excel automation.

[abu.behlim (Abu Hurera Behlim)]

Hi @Piraisoodan_J

You can use the VBA for creating pivot table.

[Piraisoodan_J]

Do you have any pre existing code for creating pivot table in VBA

[abu.behlim (Abu Hurera Behlim)]

Currently I don’t have the code but I’m trying to find the code and will share with you once I get the code

[Piraisoodan_J]

thanks

[prasath17 (Guru)]

@Piraisoodan_J - Please check the below post…

Need LINQ help: Create pivot table of date and location

@JosephNehl - If you are just looking to create a pivot table , then you can use studiox. Not sure about your full requirement. I have something like this, I had a workflow created in StudioX before. So first I switched the profile to StudioX and Opened that Workflow. Once WF is loaded, i swithced the profile again to Studio. After that, I just repointed out my input file again then tried running, boom it ran like a champ. Workflow [image] Output - After ran from Studio. [image]