Python Forum
Selenium to pick data from excel and enter into backend
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Selenium to pick data from excel and enter into backend
#1
Hi,

i have created a script that would enter enter data into backend but all the values are pre defined in it...all i want is that script should pick data from excel and enter into system.

from selenium import webdriver
from selenium.webdriver.common import keys
from selenium.webdriver.support.ui import Select


driver = webdriver.Chrome("./chromedriver")
driver.get('http://newprojects.99acres.com/acd_99.php/mainpage/login')
email = driver.find_element_by_xpath("/html/body/form/table/tbody/tr/td/table/tbody/tr[2]/td[2]/input")
email.send_keys("USERNAME DELETED")

password = driver.find_element_by_xpath("/html/body/form/table/tbody/tr/td/table/tbody/tr[3]/td[2]/input")
password.send_keys("PASSWORD DELETED")

l_button = driver.find_element_by_xpath("/html/body/form/table/tbody/tr/td/table/tbody/tr[4]/td/input")
l_button.click()

l_button2 = driver.find_element_by_xpath("/html/body/table[2]/tbody/tr[3]/td[1]/table/tbody/tr[9]/td/a")
l_button2.click()

radio_button = driver.find_element_by_xpath('//*[@id="projlistview_frm"]/table/tbody/tr[1]/td[2]/input')
radio_button.click()

XID_number = driver.find_element_by_xpath('//*[@id="projlistview_frm"]/table/tbody/tr[1]/td[3]/input')
XID_number.send_keys("279469")

radio_sbmit = driver.find_element_by_xpath('//*[@id="projlistview_frm"]/table/tbody/tr[6]/td/input')
radio_sbmit.click()

carpet_area = driver.find_element_by_xpath('//*[@id="1CARPET_AREA"]')
carpet_area.send_keys("252")

square_meter1 = Select(driver.find_element_by_id('1UNIT'))
square_meter1.select_by_value('sq m')

BHK = Select(driver.find_element_by_id("1BEDROOM"))
BHK.select_by_value('3')

Area_submit = driver.find_element_by_xpath('//*[@id="addition"]')
Area_submit.click()

carpet_area = driver.find_element_by_xpath('//*[@id="2CARPET_AREA"]')
carpet_area.send_keys("343")

square_meter2 = Select(driver.find_element_by_id('2UNIT'))
square_meter2.select_by_value('sq m')

BHK = Select(driver.find_element_by_id("2BEDROOM"))
BHK.select_by_value('3')

Area_final = driver.find_element_by_xpath('//*[@id="frm"]/table[3]/tbody/tr/td/input[5]')
Area_final.click()
Fields i want to pick from excel are XID_number, carpet_area, square_meter1, BHK

now i want to create a loop so that it should pick until all fields are entered and then move to next project id which is XID
Output:
[output]
[/output]
you can see my attached file of excel structure

Attached Files

.xlsx   options_book.xlsx (Size: 9.46 KB / Downloads: 502)
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Python Selenium (Dropdown-) data Robin_at_Cantelli 2 6,157 Dec-29-2021, 03:16 AM
Last Post: ondreweil
  Web app structure with python as backend alt19 1 1,926 Oct-06-2020, 11:28 PM
Last Post: scidam
  Extract data with Selenium and BeautifulSoup nestor 3 3,816 Jun-06-2020, 01:34 AM
Last Post: Larz60+
  Clicking on element not triggering event in Selenium Python (Event Key is not in data dkaeloredo 2 4,232 Feb-16-2020, 05:50 AM
Last Post: dkaeloredo
  Posting value from excel to Form (Python+Selenium) revanth 0 1,764 Feb-05-2020, 10:44 AM
Last Post: revanth
  Python for Backend Development jayarora 1 1,927 Dec-25-2019, 10:16 AM
Last Post: ralhanashwarya
  Selenium get data from newly accessed page hoff1022 2 2,903 Oct-09-2019, 06:52 PM
Last Post: hoff1022
  How to Caputre Data After Selenium Scroll ahmedwaqas92 3 6,960 Aug-18-2019, 12:43 PM
Last Post: ahmedwaqas92
  Unable to access javaScript generated data with selenium and headless FireFox. pjn4 0 2,501 Aug-04-2019, 11:10 AM
Last Post: pjn4
  webscrapping links and then enter those links to scrape data kirito85 2 3,147 Jun-13-2019, 02:23 AM
Last Post: kirito85

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020