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.


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


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.


1 Like

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