Running loops

[Bluemoon]

Help I'm a complete novice

I've set up a loop command and have managed to get data from EXCEL using the get muliple cells tool. I have then assigned it a variable and managed to get that variable into a web page. what i than want to do is extract the data one row at at time.(which I have a managed) The problem it just loops the the information in the same web box. I want it get the information one cell at a time do an opeartion on that data and then go to next row and so on.

[forumstaff]

Hello Bluemoon,

For your requirement, you will have to make use of the Loop "each row in an excel datasheet" and then for putting the values of the excel file to the web page, You will have to make use of the "Excel Cell Column" variable.

You can visit the following link which contains an example for the same: Excel to Web, Fill the web form with data from Excel spreadsheet

Thanks & Regards

[Bluemoon]

Hi Thanks for the reply I'm still having problems. I need to put a step in the excel column() comand. I can get the the data from a an ecell file by useing the 'get multi cells' tool and have assign it a variable. What I now want to do is paste that data one cell at a time hit the enter to go to another web page then go back to the first web page and use the next cell down from the coloumn I cipied in excel

[forumstaff]

Hello Bluemoon,

If you can send us the task file, it will be more helpful for us to guide you.

Thanks & Regards

[Bluemoon]

Hi Thanks
for the supprt. I've attached my task as a text file hope this is clear. Wheere it falls down is line 20 (see below)

Set text '$Follow_Code$' into invDeck in the webpage 'Material Global Optimization'


I want to the hit the submit button on the web page after eacheach cell has been input from the data set a copied from an excel file. I used the comand below then set up a loop

Excel : Get multiple cells from cell "A6" to cell "A23". Session: CopyCells

19 Start Loop " Each row in an Excel dataset of Session = CopyCells"
20 Set text '$Follow_Code$' into invDeck in the webpage 'Material Global Optimization'
21 Variable Operation : $Excel Column(1)$ To $Follow_Code$



I hope this is clear as I'm still very new to this.

[forumstaff]

Hello Bluemoon,

We have gone through the file you sent us and Line no. 20 is a set text control which you told has dropped. You will have to re-capture it again. For this you can use "manage web controls" command under the "Web Recorder" command in the command list.

Just type in the url of the webpage on which the "set text" control has to be captured and hit "capture".

Let us know if this doesn't help.

Thanks & Regards

[Bluemoon]

Thanks for the help I'n early there The only issue I now have is that I want Automation Anywhere to go to an open excel spread sheet and find a specific cell. For example I have an excel file with the date in colums I want my macro to find today or yesterday and paste information in the cell underneath

[forumstaff]

Hello Bluemoon,

You can make use of the "If" conditional construct for achieving your requirement.

You can use "Go to cell" command from the "Excel" commands to go to a specific cell and then you can make use of the "If" conditional statement.

THE LOGIC FOLLOWS AS:

"If" variable Equals today's date then
"Go to one cell below"
"Set cell"

"Else If" variable includes yesterday's date
"Go to one cell below"
"Set cell" ("Set cell" command from "Excel" for pasting the value)

For example:

1 Excel : Open Spreadsheet "C:\datevalue.xls". Active Sheet: Default. Session: Default
2 Excel : Go to cell "B1". Session: Default
3 Excel : Get value of Active Cell and assign to variable "Prompt-Assignment". Session: Default
4 If $Prompt-Assignment$ Equal To "9/21/2011" Then
5 Excel : Go to one cell below the active cell . Session: Default
6 Excel : Set value of Active Cell with "complete". Session: Default
7 Comment: Please enter the conditional commands here.
8 End If

Thanks & Regards