Posted by & filed under Automation, Web.

This case presents yet another example of our experience with a wide range of technologies.

We were asked by a client to fetch financial data by scraping data off several web pages. The data fetched needed to be auto-populated in an excel worksheet. The client intended to schedule the script to do periodic auto fetching of data.

We used Automation Anywhere tool to develop the script. The excel sheet had over 70 columns that we needed to populate. Each time the script was run, over 3000 rows of data were added to the sheet.

A screen shot of the generated excel sheet is pictured below –


Besides Excel sheet, the data scraped can also be inserted in a relational database or saved in text files.