For a Quick POC, I wanted to read an Excel table that contained three columns, first name, middle name, and last
name. Then I wanted to put those into variables to use further in the POC (which would including posting to a form and then also submitting to a separate URL). Excel structure looked as follows:
I used the Get Range function to extract the table (rows 2–>n), and then the FORloop to iterate the rows. For each row, I wanted to set the value of a temporary variable to match the name of the column (for use later). in this case:
The Clipboard Copy Action does not have an Index # field like the Enter Text action, and I became stumped on how to accomplish this. Eventually I resorted to using a nested FOR loop and then based upon the index of the inner look copied to the temporary variable I wanted.
While this worked, It’s hard to believe this is the proper way to accomplish this. Anyone have a better solution?
Also, is there any intent on adding Index # support to the Clipboard Copy function when using a list variable?
Below is the actions I used to perform this for those interested. While this works for 3 columns, it will not work effectivly for 10-15 columns.
Any thoughts would be appreciated.