Copy Cell from Excel to Clipboard -> New Cell Every Repeat

Help StudioX
1

Hi guys,

Just a quick one with Studio X.

I have got an Excel with all my data in Column A. I need to down this column individual and Copy Data to the clipboard.

IE:

Use Excel File → Cell A1 → Copy to clipboard → other things happen
Repeat a number of times → Use Excel File → Cell A2 → Copy to clipboard → other things happen → Repeat a number of times → Use Excel File → Cell A3 → Copy to clipboard → other things happen → etc.

I have tried a different activities but no success…?

Thanks

2

Here is a screen shot of the current Process. What I need is required between Excel File and Use Application - copying each new cell from Excel and Pasting it into Application.

Main
Main1170×2804 183 KB

3

I suspect what you want here is a “Excel For Each Row” and point at the range you want to repeat the actions for rather than trying to use a “Repeat Number of Times”.

Place that inside the “Use Application” activity and then “Type Into” the values from the “CurrentRow” that the Excel For Each row gives you.