Try installing xlrd package from Pycharm

File -> Settings -> Project: [PROJECT NAME] -> Project Interpreter-> '+' -> search 'xlrd' -> install package

i had the same problem i  updated the xlsxwriter and xlrd libraries from terminal but no effect happened the problem was still same and after that i install these libraries in pyhcarm in project interpreter  and the problem solved .means you have to install it first in your system and then into your project virtual environment.

Dear Jainesh Shah: 

Thank you for taking time to answer my question, it was very kind of yours.

I understand the compatibility issue between Odoo and Python 3.8. I had previously assured that the Odoo 13 instance is running under Python 3.6. 

The info below shows that Python 2.7 is running as the CentOS 7.8 main version of Python.

[~]# which python
     /usr/bin/python
[~]# python --version
     Python 2.7.5

Then, I enable the Python 3.6 environment and verify it:

[~]# scl enable rh-python36 bash
[~]# which python
     /opt/rh/rh-python36/root/usr/bin/python
[~]# python --version
     Python 3.6.9

When I input the command you suggested, the system informs me that the xlrd is already installed. 

[~]# python3.6 -m pip install xlrd
     Requirement already satisfied: xlrd in /opt/rh/rh-python36/root/usr/lib/python3.6/site-packages (1.2.0)
 

After that, I restart odoo13.service and go to the Odoo 13 instance and try to install the module <Base report xlsx (report_xlsx)>, to which the system returns with a message box:

And then, I get stuck. I considered removing Python 3.8 to give another try. However, I'm afraid that this might cause new software issues without any guarantee that removing the version 3.8 will solve the problem. 

Do you (or anybody else) have a further suggestion?

Thanks for your interest. 

Wisley Vilela

Hello Wisley Vilela,

Odoo doesn't have full support of python3.8. See post: https://www.odoo.com/forum/help-1/question/is-odoo-13-compatible-with-python3-8-158220

So please make sure you are running odoo with python3.6 version. And for xlrd library issue, reinstall it again using command: sudo python3.6 -m pip install xlrd.

Hope this will help you.

Regards,

Email:      odoo@aktivsoftware.com  

Skype: kalpeshmaheshwari