A repo started from the snapshot openpyxl 3.0.5, last known version of the package to work for the WAA tool.
The python environment had to be upgraded to be able to build an installer, and we cannot stick to older versions of python, numpy and so on due to deprecation of third party resources. But more recent versions of openpyxl may not produce .xlsx files suitable for Excel (LibreOffice works fine though).
replace numpy.float with float, as hinted to by numpy error message.
seems I need to install lxml. Used to be, at version 4.9.2 in 2024. Seems to still be what is installe on my python 3.9 conda env with:
mamba install lxml
Hint: may well be that lxml was writing correctly and future versions of openpyxl using other deps not.
then mamba install defusedxml installs 0.7.1 known previously 2024.
Trying to test/build a package, to figure out how I can incorporate this in the project requirement.txt file
uv venv --python 3.11 venv
more requirements.txt
. venv/bin/activate
uv pip install -U -r requirements.txt
uv pip install -e .
pytest -xrf openpyxl
# there is indeed reliance on a mature py package
uv pip install py
pytest -xrf openpyxl