Skip to main content

I want the bot to read data sets from each row of the excel and write it to the webpage search bar. Click search and capture the data from the screen change in the webpage and write it back to excel. While writing back to excel the data is only able to write the first data from the search result. How to iterate and save the data back to the excel file. Can anyone please help me in this - with some reference videos or anything. 

​@Rajalaxmi B Here’s how I would do it:

Open the Excel using Excel Advanced, leaving it in read/write mode.

Use Excel Advanced: Go to cell and have it go to the specific cell you wish to start writing upon (e.g., C2).

Open a browser window to the search page.

Loop through each row of the Excel. Use Recorder: Capture to put the value into the search box and another to click the search button. 

Have the original data from the page stored in a database* which can be queried by the value in the Excel file. Compare the data you pull from the web page (using Recorder: Capture(s)) to the value from the database. If they are different, use an Excel Advanced: Set Cell action to record the difference. Update the database with the new values.

In either case (changes or not), use an Excel Advanced: Go to cell to move “One cell below”, which keeps the “cursor” (or highlighted cell) in lockstep with the Looping row.

Save the changes in the Excel file and close.

* this could be an Access database, for example, which is simple and portable

Reply


Terms & ConditionsCookie settings