I am having some doubts regarding the use of workbook and scraping data from the web page.
I was assigned certain task which requires the following process to be followed.
Open the browser(chrome)
Enter the website url (www.carwale.com)
Enter the details of the car in the search bar of this web page.
Retrieve the name of the car and price of that car. by following process.
a). Enter the name of car in search bar
b). press “enter” and get text from the web page
c). after storing the name and cost in the variables, I need to display them in the (.xls file)
open the .xls file (spreedsheet) and store the name and cost of the cars.
I need to make use of (A)th and (B)th column for name and cost respectively.
I need to do this for 10 items (cars).
I can manage to do most of the basic operations upto retriving variables into the single variable.
But I dont know how For loop works [if it is required in this case]. Also I have no clue how to write the data which is stored in the variables into the .xls file.
I know how to read from cell. But i dont really know how writing in the cells work.
Please enlighten me.
NOTE:- I DONT HAVE MICROSOFT OFFICE INSTALLED IN MY SYSTEM. SO I USE WORKBOOK TO RUN THE .xls file IN KINGSOFT OFFICE.
Thanks and Regards,