search

pyexcel / pyexcel-io

One interface to read and write the data in various excel formats, import the data into and export the data from databases
http://io.pyexcel.org
Other
58 stars 20 forks source link

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

Closed charles-cooper closed 5 years ago

charles-cooper commented 5 years ago

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

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

chfw commented 5 years ago

please pin openpyxl < 2.6.0

chfw commented 4 years ago

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.