Open chel-ou opened 1 year ago
@chfw sorry for ping and thanks for your amazing work!
This line here:
for ranges in sheet.merged_cells.ranges[:]:
Should probably be replaced with:
for ranges in list(sheet.merged_cells.ranges)[:]:
For everyone who is struggling, here are your requirements.txt
:
pyexcel==0.6.7
pyexcel-xlsx==0.6.0
openpyxl==3.0.10
@chfw sorry for ping and thanks for your amazing work!
This line here:
for ranges in sheet.merged_cells.ranges[:]:
Should probably be replaced with:
for ranges in list(sheet.merged_cells.ranges)[:]:
For everyone who is struggling, here are your
requirements.txt
:pyexcel==0.6.7 pyexcel-xlsx==0.6.0 openpyxl==3.0.10
Thanks! Your comment is very helpful for me!
May i know ,any update on this issue?
Looks like this is causing problems with downstream applications and maintainers are warning against using pyexcel because breaking changes aren't being fixed (see above linked issues).
Also not working with macOS Ventura 13.6.4 Excel v16.83. Python 3.11.8.
@chfw sorry for ping and thanks for your amazing work!
This line here:
for ranges in sheet.merged_cells.ranges[:]:
Should probably be replaced with:
for ranges in list(sheet.merged_cells.ranges)[:]:
For everyone who is struggling, here are your
requirements.txt
:pyexcel==0.6.7 pyexcel-xlsx==0.6.0 openpyxl==3.0.10
This failed for me saying that version pyexcel 0.6.7 doesn't exist, but just pinning the openpyxl version to 3.0.10 worked 😄
Thank you!
Recent update of
openpyxl
to3.1.0
breaksread_sheet
.Below is the traceback
Pinning version of
openpyxl
to3.0.10
is a temporary workaround.