Import preview failed due to: Unable to load "xlsx" file: requires Python module "xlrd = 1.0.0".

Question

Hi I am on odoo.sh v15 fresh new install with no custom addons yet. But every time I try to import an xls or xlsx file it gives me the following error. I have checked xlrd installed version using odoo.sh shell terminal and Version 1.1.0 None [1]  is\ installed\.\ See\ images\ linked\ below
None [2] https://ibb\.co/rk2ZzrQ [3]
https://ibb\.co/4Jv469W [4]
None [5]
Import preview failed due to: Unable to load "xlsx" file: requires Python module "xlrd >= 1.0.0".

[1] https://1%5C%5C%5C.1%5

Waleed Mohsen (CorTex IT Solutions) · Accepted Answer

The Odoo 15 requirements for python version >= 3.8 is v 1.2.0 [1]
Uninstall the current version:
sudo pip3 uninstall xlrd
None [2] and install:

sudo pip3 install xlrd==1.2.0 [3]
Here you are the Odoo 15 requirements
None [4]

odoo/requirements.txt at 15.0 · odoo/odoo · GitHub [5]

[1] https://1.2.0
[2] https://xlrd==1.1.0;
[3] https://xlrd==1.2.0
[4] https://xlrd==1.1.0;
[5] https://github.com/odoo/odoo/blob/15.0/requirements.txt#L46

Jan Beckhoff · Answer

I experience this issue when there were formula errors in my import xlsx, e.g. a few cells had #NAME value.
Fixing the formula resolved the issue.

Related Posts	Replies	Views
Odoo12 babel error Solved error import	1 Nov 19	7043
Bug following a contact import : column res_partner_bank.active doesn't exist error import	1 Mar 15	5253
Error Can't Import Web Pages (Theres a Bug) error import webpage	2 Jul 25	1979
Importing Web Pages Seems Impossible Solved error import webpage	2 Jul 25	1798

This question has been flagged

Enjoying the discussion? Don't just read, join in!