0

There is an existing xlsb file where I need to fill one column with the help of pandas dataframe which has some formulas. I am stuck on the code below and do not know what to do next:

import pandas
df = pandas.DataFrame({"Purch Order": [420, 380, 390]}) # sample dataframe
df.to_excel(r'E:\Downloads\xyz.xlsb', sheet_name="xyz")

can anyone suggest to me how to write the dataframe into xlsb file?

s.dhruvi
  • 43
  • 11
  • I think you need to share the format (rows, cols,.. ) of the expected output compared to your sample dataframe. – Timeless Sep 14 '22 at 09:43

0 Answers0