0

I am trying to write several data frames into multiple sheets using fsspec in azure synapse, but the issue is that the data getting overwrite to single sheet and finally only 1 data frame is availabel in the output file. How can I correct this to have multiple sheets with all the data frames written?

my code is like this:

fsspec_excl = fsspec.open(path, account_name=adls_account_name, account_key=adls_account_key, mode="wb")
with fsspec_excl.open() as f:
 df1.to_excel(f,sheet_name="Sheet1")
 df2.to_excel(f,sheet_name="Sheet2")
 df3.to_excel(f,sheet_name="Sheet3")
suwaris
  • 1
  • I don't know the excel write well - would you expect this to work on a local file opened with `mode="wb"`? – mdurant Aug 14 '23 at 13:18

0 Answers0