excel.read fails with latest version of pyxlsb

fzumstein / python-for-excel

This is the companion repo of the O'Reilly book "Python for Excel".

https://www.xlwings.org/book

MIT License

573 stars 305 forks source link

excel.read fails with latest version of pyxlsb #7

Closed fzumstein closed 2 years ago

fzumstein commented 2 years ago

~\python-for-excel-1st-edition\excel.py in read(sheet, first_cell, last_cell)
    124         return data
    125     else:
--> 126         raise TypeError(f"Couldn't handle sheet of type {type(sheet)}")
    127 
    128 

TypeError: Couldn't handle sheet of type <class 'pyxlsb.worksheet.Worksheet'>

fzumstein commented 2 years ago

Wasn't able to replicate this anymore with Anaconda 2021.11-Windows-x86_64 / Python 3.9 / pyxlsb 1.0.7 and 1.0.9. Closing this for now.