"xlrd.biffh.XLRDError: Excel xlsx file; not supported" Exception about bittytax

[nanonano]

The work-a-round is to manually install the older version of this package.

pip install xlrd==1.2.0

[nanonano]

This issue only occurs if you have version 2.0.0 or greater of the xlrd package installed.

From the xlrd change log, .xlsx files are no longer supported https://xlrd.readthedocs.io/en/latest/changes.html

2.0.0 (11 December 2020)

Remove support for anything other than .xls files.

[ProgramerAnel]

The work-a-round is to manually install the older version of this package.

pip install xlrd==1.2.0

This one is still active,
Just fixed my issue with .xlsx

[xrchz]

Are there any plans to update BittyTax so it works with the latest xlrd? It seems like dropping xlsx support is the only real breaking change - if that was done for good reason, maybe BittyTax should also switch to xls only?

[xrchz]

Looking into this a bit more it seems like xls is an old format and xlrd is unmaintained. So perhaps BittyTax should switch to a different Excel library that is maintained like xlsxwriter. I might try to get that working.

[nanonano]

Yes plan is to migrate to openpyxl for .xlsx documents, for .xls files xlrd will remain.