Write DataFrame in .xlsx without overwrite the file

Asked Apr 16 '18 at 08:46

Active Apr 16 '18 at 08:50

Viewed 133 times

I didn't find any solution in other posts. I need to write datframes in an existing sheet of a xlsx file, but of course it overwrites the whole file. How to do it?

writer = pd.ExcelWriter('test.xlsx',engine='openpyxl')
df.to_excel(writer,sheet_name='test2',startcol=10,startrow=20)
writer.save()

Thanks

edited Apr 16 '18 at 08:50

asked Apr 16 '18 at 08:46

user9187374

Doesn't work for me, it overwrites the file. – user9187374 Apr 16 '18 at 08:52
1

did you try [this solution](https://stackoverflow.com/a/47740262/5741205)? – MaxU - stand with Ukraine Apr 16 '18 at 08:53
Ok, this works! Thanks – user9187374 Apr 16 '18 at 10:46

Write DataFrame in .xlsx without overwrite the file

0 Answers0