I need to copy/capture data from each row in excel file and pass/paste them to search field of another software in order to perform printing automation.
First, I read the first row from the excel file, copy the respective user_id1 and set it to the clipboard then paste it out to the search field. After pasting out the user_id1, the software will direct execute to the user profile 1 and I am going to print out the user profile 1. Then, I wish to perform the repeating tasks as above.
But now, I can read only one user_id from the particular excel file and the execution stopped after performing the first user_id.
Example are as below:
How do I going to loop the excel row (user_id) one by one and paste it to my search field so that I can continue with my next steps?
I looking forward to any reply. Thanks in advance.