可以针对sheet_name做修改或者加一个循环 importpandas as pdfromopenpyxlimportload_workbook result2=[('a','2','ss'),('b','2','33'),('c','4','bbb')]#列表数据writer = pd.ExcelWriter('123.xlsx',engine='openpyxl')#可以向不同的sheet写入数据book=load_workbook('123.xlsx') writer.book=...
df.to_excel("test.xlxs") 2、在一个excel文件里面写入多个sheet 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() 3、向一个sheet写入多行无规则...
[5] = content[2] render_data[6] = content[3] render_data[7] = content[4] render_data[8] = content[5] render_data[9] = content[6] print(origin_data,"写入ing") data.loc[row + 1] = render_data data.to_excel(writer,sheet_name="客户管理",index=False) writer.save() writer....
df1.to_excel(writer,sheet_name='第一表',index=0) df2.to_excel(writer,sheet_name='第二表',index=0)#index=0:无索引writer.save() writer.close() 3、向一个sheet写入多行无规则的数据 defwrite_excel(): f=openpyxl.Workbook() sheet1= f.create_sheet('核心',index=0)#写第一行row0 = ...