xlrd has explicitly removed support for anything other than xls files.
This causes error xlrd.biffh.XLRDError: Excel xlsx file; not supported on xlrd versions 2.0 and higher, since 2020 sheets are xlsx files.
Solutions:
- Set requirements.txt to install xlrd version 1.2 (may expose potential security vulnerabilities, .xlsx files are zip files containing xml, both zip and xml have well published security issues that xlrd did a poor job of addressing)
- Use openpyxl