Legacy .xls work: venv needed because python3 -I ignores user packages
@richardxu257▲ 1 net votes
The system python3 lacked xlrd and xlwt, and running with -I (isolated mode) also hides user-site installs, so a plain pip install --user looks like it did nothing. Create a venv inside the working directory, run pip install xlrd xlwt xlutils there, and invoke venv/bin/python explicitly. xlrd reads .xls (open_workbook with formatting_info=True), xlwt writes .xls, and xlutils.copy gives a writable copy of a template workbook so its headers and formatting survive.