Each Row in an Internet Explorer Table

[alexsur]

I extract a table with 100 lines from a web page but I need just the first 30 to be copied on a spread sheet. How do I limit the number of times for a loop command that uses Each Row in an Internet Explorer Table?
for better understanding I attached a sample task.

[forumsupport]

Hello,

Use conditional command, If $Counter$ is less then and equal to 30 then only copy the data. Place If command inside 'Loop for each row in Internet Explorer' block and inside If -Endif block, place commands to copy data into spreadsheet. You can find 'If Variable' command under 'Conditions/Loop' command category. The text format of commands would appear something like this,

Extract table from 'http://www.acosta.com/career/openPosition.aspx' website's '2' table
Start Loop " Each row in an Internet Explorer Table"
If $Counter$ Less than or Equal to "30" Then
Excel : Set value of Active Cell with "$Table Column(4)$". Session: Default
Excel : Go to one cell right of active cell . Session: Default
Excel : Set value of Active Cell with "$Table Column(3)$". Session: Default
.
.
.
End If
End Loop

Note: $Counter$ returns the current loop count value.

For your convenience, we have amended the task that you sent. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder and run it using RUN button.

Please let us know how it goes.

Hope that helps.

[alexsur]

Yes it's working. I think the problem was that i used Equal to 30 instead of Less then or Equal to 30

Thank you