Adding Multiple Sheet to a single Excel File
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
Comments