Hello,
You can use Excel:Get Multiple Cells command to fetch the data from range of cells. When fetching values for multiple cells, the value is assigned to the system variable $Excel Column (index)$ which you can use in “Loop for each row in an Excel Dataset”.
We have attached a sample task for your reference. To run this task,
.Please copy .atmn under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder.
. Copy book1.xls under c:\.
This task would fetch data from book1.xls and log it into temp.txt file as you mentioned.
Hope that helps.
|