Filling a web form using excel sheet values

Help Studio
1

I have an excel sheet containing different fields. I need to enter these fields to a form including text box, drop down and checkbox.After entering these values, i need to click save button and iterate this for all entries.What can i do to complete this?Is there any way to connect web page to excel sheet?

2

@Gopalakrishnan_K

Use Open Browser - for opening the browser

For Reading Excel - You can use Read Range Activity

For iteration - :You can use For Each Row activity

Hope this helps

Thanks

3

Use Excel Application scope in that give excel file path
Then
Use read range to read data from that sheet (Enter valid sheet name) And store output in DT

Then use for each row for that DT
Then it will iterate row wise
u can extract data from that row using
Row(“Name”).Tostring this is for Name column like wise you can use
For text Box use Type into
Dropdown- Use Select item

2 Likes
4

Hi,
How can i write extracted data from excel sheet to the corresponding fields in web page.

5

Use type into in for each row

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.