Make Excel Cell value Variable in Python Using Pandas

Question

I have looked for a while on this one but can't seem to find out how to pick a specific cell value in an excel worksheet and assign it to variable in python. I get a Traceback Error with the code below.

I have a number of work rules I want to assign as variables in python that are stored in an cells within an excel workhseet.

(work rules[4][2] is how I am trying to make the cell value into a variable.

Code:

work_rules = pd.read_excel(
    'D:\\Personal Files\\Technical Development\\PycharmProjects\\Call Center Headcount Model\\Call Center Work Rules.xlsx',
    sheet_name='Inputs')

historical_start_date = work_rules[4][2]

print(historical_start_date)

user14296107 · Accepted Answer · 2020-09-29 22:33:08Z

1

Found it: Use the iloc method on the excel object: work_rules.iloc(4, 2)

answered Sep 29, 2020 at 22:33

user14296107

153 bronze badges

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

Collectives™ on Stack Overflow

Make Excel Cell value Variable in Python Using Pandas

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