使用python将数据导出到表格中_如何使用python导出mapping到表表格中-优快云博客

本文介绍了一个使用Python进行数据库操作并导出数据到Excel的示例。通过pymysql连接数据库，执行SQL查询，并利用xlwt将查询结果保存为Excel文件。此过程包括连接数据库、执行SQL语句、获取查询结果、使用xlwt创建Excel文件以及将数据写入Excel。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

def get_sec_exc(time):
    # 建立连接
    conn=pymysql.connect(
        host="0.0.0.0",
        port=3308,
        user="root",
        passwd="password",
        db="mysql",
        charset="utf8"
    )
    cursor = conn.cursor()
    select_sql = """SELECT prov_name,write_kafka_statement_count,total_flow FROM providname AS A LEFT JOIN abnormalindicator AS B 
                    ON A.`prov_id` = B.`prov_id` AND B.`daily_time` LIKE %s ORDER BY A.prov_name;""" %(time)
    cursor.execute(select_sql)
    # 获取sql输出的内容
    res = cursor.fetchall()
    print(res)
    write_excel(res)
    cursor.close()
    conn.close()


def write_excel(res):
    book = xlwt.Workbook() # 创建一个excel
    sheet = book.add_sheet("12月份话单")
    title = ['字段1','字段2'，'字段3']
    i = 0
    for header in title:
        sheet.write(0, i, header)
        i +=1
    # 写数据
    #写入数据
    for row in range(1,len(res)):
        for col in range(0,len(res[row])):
            sheet.write(row,col,res[row][col])
        row+=1
    col+=1
    book.save('文件名字.xls')
    print("导出成功！")



# read_excel()
if __name__ == '__main__':
    begin = datetime.datetime(2019, 12, 1) 
    end = datetime.datetime(2019, 12, 31)
    d = begin
    delta = datetime.timedelta(days = 1)
    while d <= end:            
        time = d.strftime("%Y%m%d")
        d += delta
        print(time)
        get_sec_exc(time)