How to rename an Excel sheet?

You can do this by changing the title attribute:

import openpyxl

ss = openpyxl.load_workbook("file.xlsx")
#printing the sheet names
ss_sheet = ss['Sheet']
ss_sheet.title="Fruit"
ss.save("file.xlsx")