python3.4导excel进mysql数据库

#!/usr/bin/env python3# -*- coding: utf-8 -*-import pymysql #支持Python3.0##读取excel使用(支持03)import xlrdfrom datetime import datetimefrom xlrd import xldate_as_tuplefrom builtins import int##打开数据库# conn=pymysql.connect(host='192.168.0.200',user='root',passwd='123456',db='db_casino',port=3310,charset='utf8')conn = pymysql.connect(host='localhost', user='root', passwd='root', db='sys', port=3306, charset='utf8')##打开游标cur = conn.cursor()##将excel文件导入mysql中def importExcelToMysql(path):    workbook = xlrd.open_workbook(path)    sheets = workbook.sheet_names()    worksheet = workbook.sheet_by_name(sheets[0])    ##遍历行    for i in range(1, worksheet.nrows):        row = worksheet.row(i)        ##初始化数组        sqlstr = []        ##遍历列        for j in range(0, worksheet.ncols):            ##构造数组            sqlstr.append(worksheet.cell_value(i, j))        ##插入数据库        ##test表结构，赋值        valuestr = [int(sqlstr[0]), str(sqlstr[1]), str(sqlstr[2]), str(sqlstr[3]), str(sqlstr[4]), str(sqlstr[5]),                    str(sqlstr[6]), str(sqlstr[7]), str(sqlstr[8]),str(sqlstr[9]),str(sqlstr[10]),str(sqlstr[11]),                    str(sqlstr[12])]        ##执行sql语句        ##test表        cur.execute(            "insert into test(ID,NAME,NO,D,E,F,G,H,I,J,K,L,M) " +            "values(%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s,%s)", valuestr)    cur.close()    conn.commit()    conn.close()    # 打印信息    print("数据导入成功！")##tb_play_type表read03path = r"C:\Users\Desktop\excel文件\TEST.xls";##调用函数importExcelToMysql(read03path)