'ReadOnlyWorksheet' object has no attribute 'merged_cells'

[Pymancer]

Opening xlsx file with rs = pyexcel.iget_book(file_name='./some_file.xlsx', skip_hidden_row_and_column=False, detect_merged_cells=True) causes an error 'ReadOnlyWorksheet' object has no attribute 'merged_cells'.
May be at

pyexcel-xlsx/pyexcel_xlsx/xlsxr.py

Line 201 in 54ee10c

if self.skip_hidden_row_and_column:

should be

if self.skip_hidden_row_and_column or self.detect_merged_cells:

not

if self.skip_hidden_row_and_column:

?
Thank you for the excellent library, by the way :-)

[chfw]

which version of openpyxl?

[Pymancer]

openpyxl.version=='2.5.14'
pyexcel.version=='0.5.15'

[Pymancer]

Unfortunately

if self.skip_hidden_row_and_column or self.detect_merged_cells:

will not work as expected too because SlowSheet skips hidden columns and rows anyway.

[chfw]

Then, should I code against this combination? It is down to openpyxl, which does not support both.

[Pymancer]

It is down to openpyxl, which does not support both

At first glance openpyxl returns all rows and then pyexcel-xlsx skips hidden ones right here:

pyexcel-xlsx/pyexcel_xlsx/xlsxr.py

Line 87 in 54ee10c

if self._native_sheet.row_dimensions[row_index].hidden is False:

May be in some cases it will be ok to not to skip them, but I didn't look into that enough to assert anything.