Unable to read an excel file in python

Question

So I have a path here which contains many excel files

path = ""
files = os.listdir(path)

for file in files:
    workbook = xlrd.open_workbook(file)

I get this error:

FileNotFoundError: [Errno 2] No such file or directory: 'censo2001 (1).xls'

For reference, the first file in the folder is named 'censo2001 (1)' and it has an .xls extension. What could be the problem?

Frank · Accepted Answer · 2020-04-10 04:27:11Z

2

Try use the full path: open_workbook(path + file)

answered Apr 10, 2020 at 4:27

Frank

1,28512 silver badges26 bronze badges

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

2 Comments

Worked! Thank you! What could possibly be the problem?

Your current location is not the file location.