Python - How to send numerical values via Selenium Send Keys

Question

I have an Excel spreadsheet that has numerical values that I am trying to type into the Bing search engine via Selenium Send Keys. Whenever I try to run the code it gives me an error

TypeError: object of type 'numpy.int64' has no len()

I am able to send alphanumeric strings and alphabetical strings but just not numerical values alone. How can I resolve this?

data = pd.read_excel(excel_file, sheet_name= "Sample")
value1 = data["Number"][1]
browser.get('https://www.bing.com')
browser.find_element_by_xpath('//*[@id="sb_form_q"]').send_keys(value1)

Convert it into a string. Use str().

Arundeep Chohan
– Arundeep Chohan

2021-02-23 01:47:50 +00:00
Commented Feb 23, 2021 at 1:47 — Arundeep Chohan
– Arundeep Chohan, Commented Feb 23, 2021 at 1:47

JeffC · Accepted Answer · 2021-02-23 04:31:32Z

1

When you enter keys into an INPUT or any other tag type on the webpage, you are entering text (string) and not an int anyway. Just either change the type to string in your Excel sheet or convert it to string when you .send_keys().

browser.find_element_by_xpath('//*[@id="sb_form_q"]').send_keys(str(value1))

BTW, if you are going to have an XPath locator that just looks for an ID, you should use .find_element_by_id("sb_form_q"). It will be faster, easier to read, better supported, etc.

answered Feb 23, 2021 at 4:31

JeffC

26.4k5 gold badges35 silver badges56 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python - How to send numerical values via Selenium Send Keys

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related