Jan-14-2019, 04:36 PM
Use code tag,i have added in your post.
win32com is now very little used for excel connection,now is XLSB a binary Microsoft Excel format.
There is a library for this pyxlsb that read XLSB.
Then can also read into pandas,for greater power if need edit.
Common Excel Tasks Demonstrated in Pandas
win32com is now very little used for excel connection,now is XLSB a binary Microsoft Excel format.
There is a library for this pyxlsb that read XLSB.
Then can also read into pandas,for greater power if need edit.
Common Excel Tasks Demonstrated in Pandas
import pandas as pd from pyxlsb import open_workbook as open_xlsb df = [] with open_xlsb('some.xlsb') as wb: with wb.get_sheet(1) as sheet: for row in sheet.rows(): df.append([item.v for item in row]) df = pd.DataFrame(df[1:], columns=df[0])