python 连接数据库，查询结果写入数据到excel

##连接数据库，查询结果写入数据到excel
import pymysql
import xlwt
def get_sel_excel(file_excel):
    #建立连接
    conn = pymysql.connect(
        host = "100.100.100.0",
        port = 3306,
        user = "test",
        passwd = "123",
        db = "bigdata",
        charset = "utf8"
    )

    #建立游标
    cursor = conn.cursor()
    sel_sql = "select * from ts_vehicle_load;"
    print("开始查询表！")
    #执行sql语句
    cursor.execute(sel_sql)
    #获取查询到结果
    res = cursor.fetchall()
    print(res)
    w_excel(res)


#操作excel
def w_excel(res):
    book = xlwt.Workbook() #新建一个excel
    sheet = book.add_sheet('vehicle_land') #新建一个sheet页
    title = ['id','vehicle_load_cod