Pyexcel Error: xlrd.biffh.XLRDError: Excel xlsx file; not supported

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: