I am trying to import data from a xlsx file, using the Import button, but I get the following error, regardless of what module i use:
Import preview failed due to: Unable to load "xlsx" file: requires Python module "xlrd >= 1.0.0".
I have installed xlrd already, using the following command, on both the virtual environment and normally:
pip3 install xlrd
But the error persists. I'm sure xlrd is installed correctly, because the python interpreter can import it correctly:
(odoo-12.0) wojdob@vbox:~$ python3 -c "import xlrd; print (xlrd.__VERSION__)"
2.0.1
Also the xlrd folder is present in the site-packages odoo folder:
~/odoo-12.0/lib/python3.8/site-packages/xlrd
How do I fix this problem so I can import xlsx files? Do I need to somehow configure my odoo so it can actually see and use the library?
see my answer