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)