import pandas as pd
def generate_xlsx(file_name):
writer = pd.ExcelWriter(file_name)
dict_list = [{"xxx":"xx"},{"aaa": "xxx"}]
for item_dict in dict_list:
df = pd.DataFrame(item_dict)
df.to_excel(writer, sheet_name=f"xxx_diffrent_sheet_name", engine='xlsxwriter', index=False)
writer._save()
writer.close()