Create Pivot Table using UiPath | Excel Automation with practical demo | AutoBot by Rahul

[@AnishKumar-pe8vp]

Thanks for the demo, it is useful and elaborative.

[@glennlarenza]

Hello, thankyou for the explanation.
Can Uipath Group Rows in Pivot Table? I need to group some rows after Create Pivot Table Activty. Thanks

[@esratoprakozdemir3467]

Thank you for video.How can I create pivot table different page. I download report from ERP that included 1 page.

[@autobotbyrahul]

You can look through each sheet and pass it as parameter to the create pivot activity

[@DeEditsz]

Thank you sir superb explanation, but i have one doubt which on the use of Excel file we need to give which Excel

[@autobotbyrahul]

In which excel you need to create pivot those details you have to provide .. even the sheey also

[@SyedSAhmed3]

Hi it's done in Uipath studio x, can we do it on Uipath studio...

[@autobotbyrahul]

Its done in studio using the studiox package…In the video also studio is used

[@SyedSAhmed3]

Thank you..let me check if it works

[@SyedSAhmed3]

Bro it's not working on studio using studio x activities.... please show me how can we do it on Uipath studio using macros or Invoke VBA method...it's urgent

[@autobotbyrahul]

@@SyedSAhmed3 can you raise it in forum.uipath.com and share me the link here.

[@khooshbudave7669]

can we add " " to get the whold range of data? How to do that? here it will take range from A:C. we have millions of record everyday and we don''t know the exact range

[@autobotbyrahul]

Hello, you can use find first/last row activity and get the last index. Then pass that value to set the range.
Thanks

[@nurarynaa]

thank you for your explanation. by far this is the clearest out of all. by any chance, do you know how to filter out blanks in pivot with tabular layout?

[@autobotbyrahul]

How about removing the blank rows before doing the pivot??