The reason is that XLRD was recently updated to version 2.0.1 and only supports.xls files. So Pandas. Read_Excel (‘ xxx.xlsx ‘) will return an error.
You can install an older version of XLRD and run it in CMD:
PIP uninstall XLRD
PIP install XLRD ==1.2.0
You can also open the.xlsx file with OpenPyXL instead of XLRD:
Df = pandas read_excel (‘ data. XLSX, engine = ‘openpyxl)
Read More:
- XLRDError: Excel xlsx file； Not supported error reporting solutions
- Error in header file when calling OpenGL to open obj file in vs2013: unable to open include file: “GL / glut. H”: no such file or directories
- To solve the problem of loading rjava in installation of xlsx
- [Python] pandas Library pd.to_ Parameter arrangement and example of Excel operation writing into excel file
- npm start：Module not found: Error: Can’t resolve ‘xlsx’ in ‘/Users/huzhiqi/Downloads/web/…
- How to solve the problem of “unable to open include file:” graphics. H “: no such file or directory”
- Solution of vs unable to open source file and link library file
- Vs2019 OpenGL glut: error: unable to open include file: ‘GL / glut. H’: no such file or directory
- Solution to error reporting during installation of xlsx style
- Vs fatal error C1083: unable to open include file: “sys / socket. H”: no such file
- How to Fix Unknown error: Unable to build: the file dx.jar was not loaded from the SDK folder!
- Error loading password’s fault file (MySQL for Excel)
- R language loading xlsx error error: JAVA_HOME cannot be determined from the Registry
- A fatal error C1083 occurred when compiling C + + code under. Net: unable to open the include file: “xuhk”_ Jnihelloworld. H “: solution to no such file or directory error.
- Jstack command execution error: unable to open socket file: target process not responding or hotspot VM not loaded
- Read multiple sheets of an excel file according to npoi
- SSIS Error Code DTS_E_OLEDB_EXCEL_NOT_SUPPORTED
- The Excel connection manager is not supported in the 64-bit version of SSIS [Switch]
- IntelliSense: unable to open source file ‘StdAfx. H’
- Error: unable to open include file: ‘GL / glut. H’