Using Python to get Excel data and fill form

Question

I have an excel sheet with data I'd like to input into boxes on a web form.

import pandas as pd
df = pd.read_excel('C:\\Users\\jj\\Documents\\python_date_test.xlsx', Sheet_name=0)
(df['bx1'][0])

The output of the above code is '2'

When I insert this code into the code I'm using to webcrawl, I get the following error 'TypeError: object of type 'numpy.int64' has no len()'

Here's the code that produced this error:

mea1 = browser.find_element_by_name("data1_14581")
mea1.click()
mea1.send_keys((df['bx1'][0]))
mea1.send_keys(Keys.TAB)

mea1 refers to the first box for user input.

How can I get the value of (df['bx1'][0]) and enter it in to the box?

It's probably not related to the issue, but you should access the element using df.loc[0, "bx1"] instead of df['bx1'][0]. — AMC
– AMC, Commented Feb 21, 2020 at 23:29
I can't reproduce your error, it works for me. Pass it to a variable first then try it again — Umar.H
– Umar.H, Commented Feb 21, 2020 at 23:52

Pete Breslin · Accepted Answer · 2020-02-21 23:53:24Z

1

I haven't used this package but looking at it I believe you are on the right track, try changing the code to:

mea1.send_keys(str((df['bx1'][0])))

answered Feb 21, 2020 at 23:53

Pete Breslin

1111 silver badge6 bronze badges

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

1 Comment

Welcome to StackOverflow @pete-breslin, 1+ for your answer!