Greetings Stackoverflow Community, I am starting my first ever coding project. I have decided to go with a Web-Bot, because I constantly need to make some manual work online. I believe webbot could do it more efficiently and save some time for me. I have a spreadsheet, from which I have to copy data and paste it to a specific field at a webpage.
My Spreadsheet:
I need my bot to open the spreadsheet, find how many items there are in the first column, then open a webpage, copy Item’s A - Date/Time/Description/Item number and paste it to specific data fields in that webpage, submit this info and start to do the same for item B and so till there is no more items in the spreadsheet.
I have decided to go with Python and Selenium for Web Automation. I understand the general approach how it works but I cannot think of a way how my bot should cycle through the data in my spreadsheet. What should I use – a For Loop? Maybe something else?
I have spent hours on Selenium Tutorials it seems pretty straight forward how to open a webpage, find a field, click it and so on. I really need an idea what should I use to work with the data from my spreadsheet and how should I cycle through it. I would really appreciate any help from you. Thank you!

Aucun commentaire:
Enregistrer un commentaire