Running loop on Excel Copied column


#1

Hello,

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.

Thanks,
Vaibhav


#2

Hi @vaibhav_a1YTwn,

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