xxxxxxxxxx
df1 = pd.concat(df2)
xxxxxxxxxx
# this will write to sheet 1 of path_to_file.xlsx file
with pd.ExcelWriter("path_to_file.xlsx", mode="a", engine="openpyxl",if_sheets_exists='overlay') as writer:
df.to_excel(writer, sheet_name="Sheet1")
writer.close
xxxxxxxxxx
# if like me, if_sheets_exist = 'overlay' is overwriting your sheet
# contents instead of adding new rows, try this:
# appending to already existing cells in Sheet1
writer = pd.ExcelWriter(excelfilepath, engine='openpyxl', mode='a', if_sheet_exists='overlay')
df1.to_excel(writer, sheet_name='Sheet1', startrow=writer.sheets['Sheet1'].max_row, header=None)
writer.close
xxxxxxxxxx
import csv
with open('file_name.csv', mode='a', encoding='utf-8') as file:
writer = csv.writer(file)
writer.writerow("This text is being written in excel file.")