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

Latest version (0.5.13) does not play well with pyexcel-xlsx (0.5.6) #66

Closed
charles-cooper opened this issue Feb 14, 2019 · 3 comments
Closed

Comments

@charles-cooper
Copy link

I can't post the data but here's a traceback

Traceback (most recent call last):
  File "scripts/munge_data.py", line 216, in <module>
    res = munge(args.filepath)
  File "scripts/munge_data.py", line 160, in munge_file
    records = excel.get_data(afile=res, file_type='xlsx')\
  File "/usr/local/lib/python3.6/dist-packages/pyexcel_io/io.py", line 71, in get_data
    afile, file_type=file_type, streaming=False, **keywords
  File "/usr/local/lib/python3.6/dist-packages/pyexcel_io/io.py", line 89, in _get_data
    return load_data(**keywords)
  File "/usr/local/lib/python3.6/dist-packages/pyexcel_io/io.py", line 202, in load_data
    result[key] = list(result[key])
  File "/usr/local/lib/python3.6/dist-packages/pyexcel_io/sheet.py", line 77, in to_array
    self.column_iterator(row)
  File "/usr/local/lib/python3.6/dist-packages/pyexcel_xlsx/xlsxr.py", line 101, in column_iterator
    value = cell.value
AttributeError: 'MergedCell' object has no attribute 'value'

(python version is 3.6.7)

@chfw
Copy link
Member

chfw commented Feb 14, 2019

https://travis-ci.org/pyexcel/pyexcel-xlsx/jobs/358641126 reproduced. Will fix it.

@chfw
Copy link
Member

chfw commented Feb 15, 2019

please pin openpyxl < 2.6.0

@chfw
Copy link
Member

chfw commented May 2, 2020

it turns out that 2.6.0 had been badly wrong. Any version after 2.6.0 seemed OK. pyexcel-xlsx 0.5.8 has relax the restriction.

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

2 participants