Menu
There are many questions on this, but there has been no simple answer on how to read an xlsb file into pandas. Is there an easy way to do this?
861
Read an Excel file into a pandas DataFrame. Supports xls , xlsx , xlsm , xlsb , odf , ods and odt file extensions read from a local filesystem or URL.
You can open XLSB files with Microsoft Excel in Windows and macOS. You can also open XLSB files with OpenOffice Calc (multiplatform). However, Excel is the best option for opening XLSB files because it fully supports the formatting of Excel spreadsheets, which may include graphs and the spacing of data fields.
We can use the pandas module read_excel() function to read the excel file data into a DataFrame object. If you look at an excel sheet, it's a two-dimensional table. The DataFrame object also represents a two-dimensional tabular data structure.
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:
pip install pandas --upgrade pyxlsb - pip install pyxlsb
154
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
