Task is to read the content of excel file, retrieve the name and url of the items. Based on the obtained urls, it is necessary to determine the code and price of the item from Internet. Finally, the results should be stored in the output excel file.
In order to accomplish a task, it was divided into several sub-tasks, such as module for reading and writing excel files, web scrapping, and determining the header locations from excel content. For this purpose, selenium and pandas libraries were utilized.
To install all necessary dependencies, it is important to run "pip install -r requirements.txt" command line in root directory. Afterwards, "main.py" file can be executed.
The code can be used for identifying the information about the items from Internet and writing the obtained results into excel sheet.