Save pandas dataframe to .xlsx in managed S3 folder
In a similar vein to the question Save pandas dataframe to .csv in managed S3 folder I would like to know how to write an excel file to the same type of managed S3 folder. I have successfully been able to write CSVs, as well as, images (as explained here ) to said folder, but when I attempt to save my pandas dataframe to an excel file using the same syntax as for the CSV:
with handler.get_writer("my_df.xlsx") as w: df.to_excel(w)
I get the following error:
AttributeError: ManagedFolderWriter instance has no attribute 'tell'