TypeError with pandas.read_excel

Question

I can't load the xlsx file

import pandas
y=pandas.read_excel("as.xlsx",sheetname=0)
y

This is the error message

TypeError                                 Traceback (most recent call last)
<ipython-input-5-54208838b8e5> in <module>
      1 import pandas
----> 2 y=pandas.read_excel("as.xlsx",sheetname=0)
      3 y

c:\users\lenovo-pc\appdata\local\programs\python\python37\lib\site-packages\pandas\util\_decorators.py in wrapper(*args, **kwargs)
    206                 else:
    207                     kwargs[new_arg_name] = new_arg_value
--> 208             return func(*args, **kwargs)
    209 
    210         return wrapper

c:\users\lenovo-pc\appdata\local\programs\python\python37\lib\site-packages\pandas\io\excel\_base.py in read_excel(io, sheet_name, header, names, index_col, usecols, squeeze, dtype, engine, converters, true_values, false_values, skiprows, nrows, na_values, keep_default_na, verbose, parse_dates, date_parser, thousands, comment, skip_footer, skipfooter, convert_float, mangle_dupe_cols, **kwds)
    304         if arg in kwds:
    305             raise TypeError(
--> 306                 "read_excel() got an unexpected keyword argument " "`{}`".format(arg)
    307             )
    308 

TypeError: read_excel() got an unexpected keyword argument `sheetname`

The correct argument is sheet_name - note the underscore. I'm voting to close as a typo. — DavidW
– DavidW, Commented Aug 4, 2019 at 16:40
@DavidW. This is not a typo, but arises from running old code. The parameter sheetname was depreciated and then replaced with sheet_name in 2018. See Github issue #20920 — mjfwest
– mjfwest, Commented Jul 8, 2020 at 7:34

Neha Jirafe · Accepted Answer · 2019-08-04 16:17:12Z

31

You have a syntax error

Try

y=pandas.read_excel("as.xlsx",sheet_name=0)

answered Aug 4, 2019 at 16:17

Neha Jirafe

7615 silver badges15 bronze badges

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

Comments

HK boy · Accepted Answer · 2020-07-16 09:35:39Z

4

It seems that this "sheet_name" could be language dependent. The argument is also positional, so you can just drop "sheet_name" and write:

y=pandas.read_excel("as.xlsx",0)

I have tried version Pandas 1.0.5 and xlrd 1.2.0

edited Jul 16, 2020 at 9:35

HK boy

1,40411 gold badges21 silver badges27 bronze badges

answered Jul 16, 2020 at 7:16

Frode Frisvoll

411 bronze badge

Comments

Alex Dowd · Accepted Answer · 2022-11-18 15:25:52Z

0

Syntax error. Should be:

sheet_name = 'xxx'

answered Nov 18, 2022 at 15:25

Alex Dowd

391 silver badge10 bronze badges

1 Comment

Derek O Over a year ago

how is this different than the other answers already posted?

Subash · Accepted Answer · 2020-10-09 18:40:05Z

-1

install xlrd from command prompt using below:

conda install xlrd
pip install xlrd

It is referred to as Sheetname

edited Oct 9, 2020 at 18:40

Subash

8951 gold badge8 silver badges19 bronze badges

answered Oct 9, 2020 at 17:10

AkshayRY

416 bronze badges

1 Comment

Ruli Over a year ago

OP's problem was caused just by a simple typo, I don't think this answer is helpful here. You might want to clarify why you think this is helpful by editing it.

Collectives™ on Stack Overflow

TypeError with pandas.read_excel

4 Answers 4

Comments

Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related