笔记：多个dataframe追加写入excel的同一个sheet里

https://stackoverflow.com/questions/38074678/append-existing-excel-sheet-with-new-dataframe-using-python-pandas

多个dataframe追加写入excel的同一个sheet里

import pandas as pd
from sqlalchemy import create_engine


con = create_engine('mysql+pymysql://root:123@localhost:3306/my_test?charset=utf8')

query_sql = "SELECT * FROM  `sheet1`"



def append_df_to_excel(filename, df, sheet_name='Sheet1', startrow=None,
                       truncate_sheet=False,
                       **to_excel_kwargs):
    """
    Append a DataFrame [df] to existing Excel file [filename]
    into [sheet_name] Sheet.
    If [filename] doesn't exist, then this function will create it.

    Parameters:
      filename