import xlwt class file: def fileUp(ff): sql = "select * from t_table where code=?" conn = sqlite3.connect("test.db") c = conn.cursor() gg = c.execute(sql, ff) df = gg.fetchall() ws = xlwt.Workbook(encoding='utf-8') worksheet = ws.add_sheet("猪日食量") cloum = ['id', 'coded', 'weight', 'feedIntake', 'time'] for i in range(0, len(cloum)): worksheet.write(0, i, cloum[i]) for rowy, row in enumerate(df): for colx, text in enumerate(row): # row是一行的内容 worksheet.write(rowy + 1, colx, text) ws.save("E:\\tt.xls") if __name__ == '__main__': ff=('895463152421',) file.fileUp(ff)