python多个dataframe 写入同一个sheet页_笔记：多个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 : File path or existing ExcelWriter

(Example: '/path/to/file.xlsx')

df : dataframe to save to workbook

sheet_name : Name of sheet which will contain DataFrame.

(default: 'Sheet1')

startrow : upper left cell row to dump data frame.

Per default