Python dataframe write into specific existing excel file

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • hofeher
    New Member
    • Jun 2016
    • 1

    Python dataframe write into specific existing excel file

    Trying to write dataframe into existing excel file to a specific column without deleting existing data. Code sample:
    Code:
    import pandas
    
    from openpyxl import load_workbook
    
    writer = pd.ExcelWriter('test.xlsx', engine='xlsxwriter')
    
    df.to_excel(writer, sheet_name='sheet1', startrow=1, startcol=57, index=False, engine='openpyx1')
    
    writer.save()
  • dwblas
    Recognized Expert Contributor
    • May 2008
    • 626

    #2
    "pd" & "df" have not been declared, if that is what you are asking about.

    Comment

    Working...