How to automate "edit and update" option through Data driven approach?

Question

Here how to specify which list we have to edit.How to mention it in excel

Comments

Can you add a little more details? What do you mean by edit and update option?

---

For example...
http://demo.automationtesting.in/WebTable.html

In which, how to edit the particular list based on the input from excel.

Answer 1

@sbala,

As per your message, what you are looking for is to read data from excel file and update the same on the above URL.

I suggest you first write a code to read data in the excel file. You can use Apache POI or JXL libraries to read test data from excel file.

Now, when you have data retrieved, you will have to write a code to edit (You have to use doubleClick instead of click) one of rows.

You can identify each row as List<WebElement> and then edit the row you want to edit and use data from the excel file that you have read in the above step.

Feel free to write back if you need more information.