Dynamically select the column in excel

May I give a parameter to the yellow part?

Like list - [1,2,3,4,5,6]… if I can do it.

I can use for-each activity to dynamically select the column in excel.

Thank you

Hi @Chen_Kenny
Yes you can pass variable inside a selector by

  1. Declare a variable , Let’s say ‘tableColValue’
  2. Pass it into selector in between ‘"+tableColValue+"’
    And increment the value as required.
    Hope this helps. Let me know if you need further more information.
2 Likes

Hi,

We can set the value from variable using selecting it and right click on it as the following image.

img20210101-1

Please assign from item of the list to string or int32 variable in advance, because only string or integer variable is valid in this way.

Regards,

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.