Python Automation | Part 10 : Automatic Form Submission using Python |Python Selenium Web Automation

In this Python Automation video, we are gonna be automating Form Submission such that we can submit data from an excel file or csv file or similar, regardless of the quantity, whether it be 1000, 10k or 100k. The idea is fetching data, processing data, and submit each of them into the form. We will go through three important things in this video :
1) Read/Fetch data from an excel/csv/simlar file using Pandas, the popular and loved package by Data Scientists.
2) Handling inputs such as radio input, checkbox input and select elements using Selenium.
3) Executing JavaScript in Selenium.
We will leverage Python Selenium for this Automatic Form Submission in Python Automation.

Join Code Band Community❤️
WhatsApp Group Link:

Telegram Group Link:

Don't forget to give a ⭐️ to the repo.

References :

Subscribe | Code Band

Other videos in Code Band:

:) You Can Find Me On:

[ajmalbinnizam]

keep going bro..
addicted to the web automation playlist 😍😍

[TevfikBagcivan]

This video is very helpful for web automation. Thank you

[tigreonice]

Related with selenium: I have an excel or csv file, some cells have NaN value. I want when there's no value (Nan) the driver doesn't fill in the web input(with 'Nan' or nan), just skip it to the next line code instruction.... how can I do that?

[sidtech]

Thank you so much ❤
that 2nd way to submit was really helpful for me

[creshalybeau]

Hello do you have any idea how to automatic web form with datepicker? I have excel file with date(dd-mm-yyyy) and rainfall coloumn for a month. How can i autofill them with a form consist of date picker and rainfall entry. Thank you

[davidramosmartinez]

Hi there,
Thanks for share your knowledge, I'm having an issue entering numbers from an excel.
Python is giving me this error "object of type 'numpy.int64' has no len() ", I google it and it telling me that is error happend when you try to add types such as integer, float, boolean, long, complex.
What other fuction can I use in this case?


Kind regards!

[harriscastro]

This a great video. It seems that the xpath for choosing radio button is not working when used in MS Forms. I tried it and it just skips the radio button question for me. Do you have any alternative way to choose a radio button based on MS Forms? Thanks!

[madhav]

Hey just wanna thank you for this precious knowledge. I have a question, that what if the script brokes somehow in between for any particular row data of excel, how can we tackle this thing and continue our script for other row data or index?

[madhav]

Have you ever explained in any of your video that how can we scrap the values from the Web and fills back the values in excel for a particular row, then plss refer your tutorial or make a tutorial, it would be really helpful. Thank you ❤️❤️

[awaismaz]

How to deal with 'unseen' forms. If I have a url and I need to find forms on that url and submit them automatically without opening them and finding xpath, what will be the procedure?

[sanielsainoding]

Subs here, may I ask if I run again the script it will run same entry.? I just wanted to skip the entry once it is done. Please help

[royalwinautomatedsoftware]

Hai sir, ur video super. I learn so much ur channel. I have one doubt I'm using excel data python. Excel sheet cells I have created formula. Excel read data python program only copy formula not value. Please help me I need excel rows read values only. Please advise sir.

[royalwinautomatedsoftware]

Hai sir, ur video super. I learn so much ur channel. I have one this video I try read data is work. I want write data for excel can plz send format for write data in pandas

[ThamizhiShanmugam]

Hi, does this work for Microsoft Forms?

[mehulpanchal]

Hi Code Band,
Need your help to find Combo Box and entering the value .Can you please help me on this

[moeinht]

I used selenium to click a page
I need to use Chrome cache and cookies
But Chrome works as a test software

please guide me

[srinivasanseenu]

I am getting this error "name 'send_keys' is not defined " .
I tried both the package, but still same issue
from import Keys
Import

[stembabe]

How can we edit the script to run so that it automatically fills out the patient information only after inputting the the first form.

[amarnath]

3:58-4:05 You said that it has been already discussed it's simple. please share the link of the discussion, I need that

[akm]

Hey
Can you please help me on how to fire a website using single sign on.. because as soon as the website detects that chrome is being controlled by automation test software it does not allow access.