df.to_excel("test.xlxs")

writer=pd.ExcelWriter('filename.xlsx')

...

df1.to_excel(writer,sheet_name='第一表',index=0)

df2.to_excel(writer,sheet_name='第二表',index=0) #index=0：无索引

writer.save()

writer.close()

def write_excel():

    f = openpyxl.Workbook()

    sheet1 = f.create_sheet('核心',index=0)

    #写第一行

    row0 = ["代码","名称","价格","数量"]

    sheet1.append(row0)

    list1 = ["【市场概况】："]

    sheet1.append(list1)

    list2 = ["AA：", a ,"BB：", b]

    sheet1.append(list2)

    f.save('test.xlsx')

write_excel()

df= pd.DataFrame(pd.read_excel('test.xlsx')) #读取原数据

df_rows = df.shape[0] #获取行数

#增加一条数据

df.loc[df_rows] = [a1 , b2 , c3 , d4] #与原数据同格式

df.to_excel('test.xlsx', sheet_name='sheet1', index=False, header=True)