With the 1.0.0 release of pandas – January 29, 2020, support for binary Excel files was added.
import pandas as pd
df = pd.read_excel('path_to_file.xlsb', engine="pyxlsb")
Notes:
- You will need to upgrade pandas –
pip install pandas --upgrade - You will need to install
pyxlsb–pip install pyxlsb