I have an application and an excel. In that excel, i have some name of ten companies one by one in each row. I have recorded a sequence of steps to be performed in my application. While running that recorded sequence, at one of the steps in the middle, robot has to go to that excel file and fetch the name of the first company and should come back to application to paste the name of selected company from that excel and do the remaining process under that recorded sequence. Once the process of recorded sequence completes, it has to repeat the same process with the next companies name present in the excel.
How can i make the bot to read each cell from the excel ? And thereby to store it under some variable to perform further recorded sequence.
Please help me to solve this…Thanks in advance