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

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

  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

you mean macro or code ?

VB code using Invoke code activity