Loop through Excel Dataset

[GMPLLC]

Can't figure out how to do simple loop;

Open spreadsheet
Loop through
grab cell value in column three
append value to .txt
End loop


My end goal is to have a list variable in txt file.
Any ideas would be greatly appreciated. Thx
TK

[GMPLLC]

For reference I have attached what I have so far. As you can see I have nothing in the way of appending the value to the txt file. My goal is to have a txt file with cell A3=A4,A5,A6,A7 and so on.

[forumsupport]

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.