How to write back a pandas dataframe in one of the sheet of the workbook

[punit-mahipal]

I have a .xlsb file which I am able to read as dataframe using pyxslb libray but after doing what I needed to do with the dataframe, I need to update the sheet. can you please help me with it.

[willtrnr]

Writing is currently not supported and, given the effort required to add that, not expected for the foreseeable future.

You may want to look into using openpyxl to create an xlsx file instead or maybe simply writing to a CSV file would fit your needs.