May-09-2019, 07:00 PM
I found a way around like this.
from openpyxl import load_workbook workbook1 = openpyxl.load_workbook('file.xlsx') writer = pd.ExcelWriter('file.xlsx', engine='openpyxl') writer.book = workbook1 new_file.to_excel(writer, sheet_name='Shee1',index=False,startrow=2,startcol=1) writer.save() writer.close()