Running loop on Excel Copied column



I am opening MS Excel using Launch Application and copying a column with 7 values in a list variable.
My requirement is to run a loop on the 7 selected values one by one. But the 7 values are being considered as one single value and loop is running only once for all the 7 values.
I have tried to store the column values into a string variable, use split string function with “Windows line break (CR+LF)” and store it in a List variable and then run the loop but Split String seems not to be working.
Any inputs will be helpful.



Hi @vaibhav_a1YTwn,

Excel divides rows by LF when copying data to the clipboard, when copying from Excel you should select the Linux separator.