Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

I get Excel xlsx file not supported #5

Open
nevasha27 opened this issue May 2, 2021 · 5 comments
Open

I get Excel xlsx file not supported #5

nevasha27 opened this issue May 2, 2021 · 5 comments

Comments

@nevasha27
Copy link

excel2json-3 --file './Assessment.xlsx'
Excel xlsx file; not supported
'NoneType' object is not iterable

here what pip list shows
Package Version


appdirs 1.4.4
certifi 2020.12.5
chardet 4.0.0
distlib 0.3.1
et-xmlfile 1.1.0
excel2json 1.0.1
excel2json-3 0.1.6
filelock 3.0.12
idna 2.10
openpyxl 3.0.7
pip 21.1.1
pipenv 2020.11.15
requests 2.25.1
setuptools 49.2.1
six 1.15.0
urllib3 1.26.4
virtualenv 20.4.4
virtualenv-clone 0.5.4
wheel 0.36.2
xlrd 2.0.1

What could I be doing wrong?

I have: Python 3.9.4

I followed the instructions in USES.md

python3
Python 3.9.4 (v3.9.4:1f2e3088f3, Apr 4 2021, 12:32:44)
[Clang 6.0 (clang-600.0.57)] on darwin
Type "help", "copyright", "credits" or "license" for more information.

from excel2json import convert_from_file
EXCEL_FILE = './Assessment.xlsx'
convert(EXCEL_FILE)
Traceback (most recent call last):
File "", line 1, in
NameError: name 'convert' is not defined

@nevasha27
Copy link
Author

I am a newbee to python and so may well have questionable install when it comes to excel2json.

@GamerBoy2K
Copy link

Facing the same problem

Excel xlsx file; not supported
'NoneType' object is not iterable

@cindyteng
Copy link

Is there an update regarding this issue?

@hoferdan
Copy link

hoferdan commented Nov 4, 2022

Even though this is an old issue, i figured out the problem.
excel2json-3 is using the package xlrd which stopped supporting xlsx files in version 2.0.0.

@yilverdeja
Copy link

Even though this is an old issue, i figured out the problem. excel2json-3 is using the package xlrd which stopped supporting xlsx files in version 2.0.0.

Good catch, it worked for me when I downgraded the xlrd version to 1.2.0 using

pip install xlrd==1.2.0

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants