search

toransahu / excel2json-3

[PyPi Package] Convert Excel Sheet into JSON file.
GNU Affero General Public License v3.0
12 stars 5 forks source link

I get Excel xlsx file not supported #5

Open nevasha27 opened 3 years ago

nevasha27 commented 3 years ago

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 commented 3 years ago

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

GamerBoy2K commented 3 years ago

Facing the same problem

Excel xlsx file; not supported 'NoneType' object is not iterable
cindyteng commented 3 years ago

Is there an update regarding this issue?

hoferdan commented 1 year ago

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 commented 1 year ago

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