RandumbTune RandumbTune - 1 year ago 314
Python Question

openpyxl: Gives error on load_workbook()

The following code was executing fine, until I setup the development environment on a different computer.

workbook_obj = load_workbook(filename=xl_file, data_only=True, use_iterators=True)

I get the following error:

TypeError: load_workbook() got an unexpected keyword argument 'use_iterators'

pip freeze
command shows that I was using
openpyxl 2.3.5
previously when the code worked fine. My current version is

Is this a bug in

Answer Source

The use_iterators keyword was removed since 2.4.0. Use read_only=True instead.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download