Adding Multiple Sheet to a single Excel File

PHOTO EMBED

Sat Jul 15 2023 16:49:53 GMT+0000 (Coordinated Universal Time)

Saved by @Saravana_Kumar

def excel_maker(dataframe,file_name,path=os.getcwd(),sheetName="Sheet"):
    file_name = os.path.join(path, f'{file_name}.xlsx')
    if not os.path.exists(file_name):
        writer = pd.ExcelWriter(file_name, engine='openpyxl')
        dataframe.to_excel(writer, sheet_name=sheetName,index = False)
        writer.save()
        writer.close()
    else:
        writer = pd.ExcelWriter(file_name, mode='a', engine='openpyxl')
        dataframe.to_excel(writer, sheet_name=sheetName,index = False)
        writer.save()
        writer.close()
        

data = pd.DataFrame(reference_id)
excel_maker(data,file_name=f'new_{billboard_type}',path=output_file_path,sheetName=collection)
content_copyCOPY