Setup Data Import Error - AttributeError: 'Workbook' object has no attribute 'sheetnames'

[ronna]

Steps to reproduce

Import the test.xlsx setup data file or custom setup data file

Current behavior

It throws a traceback:

We’re sorry, but there seems to be an error…
Here is the full error message:

Display traceback as text

Traceback (innermost last):

Module ZPublisher.Publish, line 138, in publish
Module ZPublisher.mapply, line 77, in mapply
Module ZPublisher.Publish, line 48, in call_object
Module bika.lims.exportimport.dataimport, line 127, in call
Module bika.lims.exportimport.load_setup_data, line 106, in call
Module bika.lims.exportimport.setupdata, line 87, in call
AttributeError: 'Workbook' object has no attribute 'sheetnames'

Expected behavior

Setup data should be correctly imported

Screenshot (optional)

[rockfruit]

rockfruit [17:22] it's an incompatibility of the openpyxl library. The newer version has compatibility with newer versions of plone's lxml dependency (...by implementing a fallback for it's remaining incompatibility with lxml...) and many improvements, but does not have backwards compatibility with it's own api.

[mikejmets]

@ronna is the an installation of bikalims master. If so you need openpyxl = 2.4.7, previous buildouts had it pinned at 1.x.y. Where did you get your buildout?

[lemoene]

please be sure to commit any fixes to code or data test.xlsx to the 3.2 release - is critical for newbs to configure their systems with

fixed by Mike for the demo, am leaving it open here