For some reason, I saved the EXCEL file in the format of xlsb (and for 3 years!), And it wasn't read by BI tools in that format, so I had to change the format one by one by hand and save it. I was desperate, so I checked if it could be done with Python. I didn't have much information on Qiita, so I'll write it down.
With the Pyxlsb library, it's done.
import pandas as pd
import pyxlsb
import_file='sample.xlsb' #Location of read file
sheet= 'sheet1' #Sheet name of the read file
export_file='sample.xlsx' #File dump destination
df_read = pd.read_excel(import_file,sheet,engine='pyxlsb') #Read xlsb file
df_read.to_excel(export_file) #Save as xlsx
[XLSB file to Pandas Python](https://www.it-swarm-ja.tech/ja/python/xlsb%E3%83%95%E3%82%A1%E3%82%A4%E3%83% AB% E3% 82% 92pandas-python / 833269674 /)
Recommended Posts