python excel数据导入到Mysql数据库中

python 操作数据库

import pymysql
from openpyxl.reader.excel import load_workbook

def importExcelToMysql(cur, path):
    num = 1
    # 读取excel文件
    workbook = load_workbook(path)
    # 获得所有工作表的名字
    sheets = workbook.get_sheet_names()
    # 获得第一张表
    worksheet = workbook.get_sheet_by_name(sheets[0])

    # 将表中每一行数据读到sqlstr数组中
    for row in worksheet.rows:
        if num == 1:
            num += 1
            continue
        sqlstr = []
        for cell in row:
            sqlstr.append(cell.value)

        valuestr = [str(sqlstr[0]), int(sqlstr[1]), int(sqlstr[2]), int(sqlstr[3])]
        # valuestr = tuple(valuestr)
        # 将每行数据存到数据库中
        cur.execute("insert into student(name1, language1, math1, english1) VALUES(%s, %s, %s, %s)", valuestr)

# 输出数据库中的内容
def readTable(cursor):
    # 选择全部
    cursor.execute("select * from student")
    # 获得返回值， 返回多条记录， 若没有结果则返回
    results = cursor.fetchall()
    for i in range(0, results.__len__()):