Nice one Deepak. But once the robot created a pivot table manually we need to select the columns or rows by opening excel file. Can we define in the activity it self that use these Headers as Rows and Columns like that?
@@vishnu_addagada You can do that on 2 ways: 1. Selecting the data to make pivot using 'select range' activity. Then using send hotkey, pass Alt+N+V+T (Will open the pivot dialog box) Now, select the row,column etc by using "find element" or "find image" and drag and drop to required fields. The Drag and drop can be done by using a combination of'click up' and 'click down' property in click activity. 2. This method we have to write the code using VB code (Invoke Code Activity) . In the code, we need to provide the column name and need to mention which columns need to be in row labels. columns, filters and values. Hoping this will resolve your doubts. If not then let me know then I will try to figure out solution for you. Thanks again for watching my content.
Mr. Mohanbabu, thanks for watching the content. refresh pivot table activity is available inside the excel. If it is not available in your activity panel then you have to download it from manage activity
Nice article on pivote table
Thanks for watching the content
Nice one Deepak. But once the robot created a pivot table manually we need to select the columns or rows by opening excel file. Can we define in the activity it self that use these Headers as Rows and Columns like that?
Thanks Vishnu for watching the tutorial. yes its very much possible but we have to use excel activity.
@@DeepakRai Thank you for your Kind reply Deepak. Did not understand what you mean Excel Activity? Would you please more elaborate ?
@@vishnu_addagada You can do that on 2 ways:
1. Selecting the data to make pivot using 'select range' activity. Then using send hotkey, pass Alt+N+V+T (Will open the pivot dialog box) Now, select the row,column etc by using "find element" or "find image" and drag and drop to required fields.
The Drag and drop can be done by using a combination of'click up' and 'click down' property in click activity.
2. This method we have to write the code using VB code (Invoke Code Activity)
.
In the code, we need to provide the column name and need to mention which columns need to be in row labels. columns, filters and values.
Hoping this will resolve your doubts. If not then let me know then I will try to figure out solution for you.
Thanks again for watching my content.
@@DeepakRai can you share that vb code please
Hi.. How can we define the rows and columns... please help..
bro, in this video you used the "Refresh Pivot Table" know. In UiPath, Where and How the Refresh Pivot Table is worked?
Mr. Mohanbabu, thanks for watching the content. refresh pivot table activity is available inside the excel. If it is not available in your activity panel then you have to download it from manage activity