Python读入Excel数据存入MySQL

import xlrd
import pymysql
from datetime import datetime
from xlrd import xldate_as_tuple

# 打开数据所在的工作簿，以及选择存有数据的工作表
book = xlrd.open_workbook("测试表.xls")
sheet = book.sheet_by_name("Sheet1")
# 建立一个MySQL连接
conn = pymysql.connect(
    host='127.0.0.1',
    user='root',
    password='111111',
    db='Test',
    port=3306,
    charset='utf8'
)
# 获得游标
cur = conn.cursor()
# 创建插入SQL语句
query = 'insert into incrementelectrictable(IncremenValue, IncremenType, Address, CollectionDate, AreaName) values (%s,%s,%s,%s,%s)'
# 创建一个for循环迭代读取xls文件每行数据的, 从第二行开始是要跳过标题行,
i = sheet.nrows
for r in range(1, sheet.nrows):
    IncremenValue = sheet.cell(r, 0).value
    IncremenType = sheet.cell(r, 1).value
    Address = sheet.cell(r, 2).value
    CollectionDate = datetime(*xldate_as_tuple(sheet.cell(r, 3).value, 0)).strftime('%Y-%m-%d %H:%M:%S')
    AreaName = sheet.cell(r, 4).value
    # Comment = sheet.cell(r, 5).value
    # EquipmentName = sheet.cell(r, 3).value
    # Area = sheet.cell(r, 4).value
    # AddTime = cell_date
    # Status = sheet.cell(r, 6).value
    values = (IncremenValue, IncremenType, Address, CollectionDate, AreaName)
    # 执行sql语句
    cur.execute(query, values)
cur.close()
conn.commit()
conn.close()
columns = str(sheet.ncols)
rows = str(sheet.nrows)
print("导入 " + columns + " 列 " + rows + " 行数据到MySQL数据库!")