Breaking News: Grepper is joining You.com. Read the official announcement!

Excel file format cannot be determined, you must specify an engine manually

Kiiru answered on May 30, 2022 Popularity 10/10 Helpfulness 2/10

answer Excel file format cannot be determined, you must specify an engine manually

Excel file format cannot be determined, you must specify an engine manually

Comment

#When an excel file is opened for example by MS excel a hidden temporary file is created in the same directory:
~$datasheet.xlsx

#So, when you run the code to read all the files from the folder it gives you the error:
Excel file format cannot be determined, you must specify an engine manually.

#When all files are closed and no hidden temporary files ~$filename.xlsx in the same directory the code works perfectly.

Popularity 10/10 Helpfulness 2/10 Language python

Source: stackoverflow.com

Tags: excel file-format python

Link to this answer
Share Copy Link