How to create Pivot table using Uipath if we do not know table name and table range

Help
1

Well here are two scenarios where I am not able to create Pivot table using Uipath activities

  1. I do not know what is the table name, sheet name and table range

  2. I know the sheet name but I do not know the range of the table nor table is created

any optimized solution for this available ?

any idea on this part
Thanks & Regards

2
  1. You can get the sheet name using get sheet names activity but

for both the questions, the solution is to use the VB code to make the data pivot

3

you mean macro or
vb.net code ?

4

VB code using Invoke code activity