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

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

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.

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.