Phenomenon:
code
# content is a table data of byte type
sheet = pyexcel.get_sheet(file_type='xlsx', file_content=content)
report errors
xlrd.biffh.XLRDError: Excel xlsx file; not supported
reason
The installed pyexcel package version is too old
pyexcel-xls==0.5.8
pyexcel==0.5.9.1
pyexcel-xlsx==0.5.6
Solution:
Updated version (latest version)
pyexcel==0.6.7
pyexcel-io==0.6.4
pyexcel-xls==0.6.2
pyexcel-xlsx==0.6.0
Read More:
- [Solved] Cannot open .xlsx file, xlrd.biffh.XLRDError: Excel xlsx file; not supported
- Python openpyxl excel open zipfile error resolution: zipfile.BadZipFile: File is not a zip file
- [Solved] RuntimeError: cuda runtime error (801) : operation not supported at
- Windows10 DOTA_devkit Error: TypeError: ‘>=‘ not supported between instances of ‘NoneType‘ and ‘str‘
- RuntimeError: Non RGB images are not supported [How to Fix]
- VScode debug error: configured debug type ‘Python’ is not supported
- [Solved] Matplotlib scatter Draw Error: TypeError: ufunc ‘sqrt‘ not supported for the input types…rule ‘‘safe‘‘
- `Model.XXX` is not supported when the `Model` instance was constructed with eager mode enabled
- [Solved] Odrive gui Error: Do not use the development server in a productioun and supported version of the Socket
- Python + Requests +Excel+Jenkins interface automation
- Python reads excel and stores it in the list according to the header hash copy.deepcopy
- python2.7 ExcelWriter error Exception caught in workbook destructor. Explicit close() may be require
- [Solved] ERROR: THESE PACKAGES DO NOT MATCH THE HASHES FROM THE REQUIREMENTS FILE
- [Solved] ValueError: row index was 65536, not allowed by .xls format
- [Solved] RuntimeError: ProcessGroupNCCL is only supported with GPUs, no GPUs found
- [Solved] ERROR: URL ‘s3://‘ is supported but requires these missing dependencies: [‘s3fs‘]. To install dvc wi
- ImportError: libcublas.so.9.0: cannot open shared object file: No such file or directory
- PIP Install Mysqlclient error C1083: Cannot open include file: ‘mysql.h‘: No such file or directory
- [Solved] AttributeError WriteOnlyWorksheet object has no attribute cell
- Error reading file by pandas pandas.errors.EmptyDataError: no columns to parse from file