Tuesday, April 17, 2018

Pandas and XlsxWriter

Can you add an Excel table using a pandas dataframe to an existing worksheet?

No. What you can do is use pandas.dataframe.to_excel to create the sheet with the dataframe inserted to start from a certain row, and then you can use

pandas.ExcelWriter to capture the book and sheet and then use

sheet.write to insert values..

No comments: