在excel文件中写入数据帧列表

import pandas as pd
from openpyxl import Workbook
from openpyxl.utils.dataframe import dataframe_to_rows

df1 = pd.DataFrame({'列1': [1, 2, 3, 4],
                    '列2': ['A', 'B', 'C', 'D']})

df2 = pd.DataFrame({'列1': [5, 6, 7, 8],
                    '列2': ['E', 'F', 'G', 'H']})

df_list = [df1, df2]

wb = Workbook()
ws = wb.active

for df in df_list:
    for row in dataframe_to_rows(df, index=False, header=True):
        ws.append(row)

wb.save('dataframes.xlsx')