Completing web forms with data in Excel

[billt]

I have set a task to compete a web form based off data in Excel. I have the task completed and the first few times it worked however, now I am having problems. I am using the Excel commands to navigate from one cell to another and setting the new cell as active. Once the first two fields are competed and it is to navigate to the third, the program jumps far left and several rows down. I have reviewed the task to ensure that is set to only move one cell and it is. Does anyone have suggestions on how to prevent this from happening?

[forumsupport]

Hello,

What you can do is, get range of data using Get Multiple Cells option of Excel command into excel dataset and using 'Loop for each row in an Excel dataset' command retrieve the data from excel dataset using $Excel Column$ variable. Whenever you have retrieved a range of cells from excel using Excel-> Get Cells->Get Multiple Cells., the rows and columns of the range are stored in the System Variable $Excel Column$ . Let's say you retrieved a range of cells from excel that have 2 columns. You can access the two columns of the table by calling $Excel Column(1)$, $Excel Column(2).

Please refer to following example (web Link), which explains how to use excel sheet to feed data in particular web application and similarly ,you can use it for other types of application.
http://www.tethyssolutions.com/T85.htm

Hope that helps. If you could tell us more about your case like URL of website and sample excel file then, we would be able to help you more with specific task.

[billt]

I will try using the Excel get multiples cells command, however, what I dont understand is that this task has worked several times. It just all of a sudden stopped working and no one else would have had access to the task. Any ideas as to why this would happen?

[forumsupport]

Hello,

Can you please upload your task so we can look into it and suggest solution?

You can locate your task by selecting your task from Task List, right clicking that particular task and selecting 'Locate on disk' from context menu. Otherwise, you can also send text format of task. For that, open your task in a Task Editor, go to Tools->Save as text file and send this text file.

It would help us investigate further.