Python Pandas Read_Excel() Module Not Found

Import Excel file Python Pandas (File not found)

Still not able to use the read_excel properly, I used the read_clipboard function. Odd thing is that I can actually write multiple Excel files from my dataframe.

For now, this is what I need.

Thanks for your input.

KR ~M

Edit:

I actually found the issue. The file was named Testsheet.xlsx (under the hood, it actually reads Testsheet.xlsx.xlsx. I renamed the file to Testsheet and everything worked.

Unable to run pd.read_excel for scripts that previously worked

I had similar problem in past, I just updated my xlrd module.

python -m pip install --upgrade xlrd

and also try to put r in file path

pd.read_excel(r"C:\Users\")

I hope you're using python-3.x

Related Topics