选择本数据库中任意一张表，在excel中整理20条数据，封装一个函数 insert

import openpyxl
import pymysql
import re

import yaml

def insert_data_from_excel(excel1_path,table_name):
    wb = openpyxl.load_workbook(excel1_path)
    sheet1 = wb.worksheets[0]
    rows = sheet1.iter_rows()  # 获取所有行
    database = pymysql.connect(host='localhost',user='root',
                password='Dsfz123456@',port=3306,database='company22',charset='utf8')
    cur = database.cursor()
    for row in rows:
        c_values = []
        for c in row:
            if c.value is None:
                c.value='NULL'
            c_values.append(c.value)
        vaue_tuple = tuple(c_values)
        sql = "INSERT INTO {} VALUES{};".format(table_name,vaue_tuple)
        sql = re.sub("'NULL'", "NULL", sql)
        cur.execute(sql)
    database.commit() # 数据改动生效
    cur.close()
    database.close()

# insert_data_from_excel('D:jncpythonstudentdata.xlsx','student')

def insert_data_from_excel_2(excel1_path,table_name):
    wb = openpyxl.load_workbook(excel1_path)
    sheet1 = wb.worksheets[0]
    rows = sheet1.iter_rows()  # 获取所有行
    database = pymysql.connect(host='localhost',user='root',
                password='Dsfz123456@',port=3306,database='company22',charset='utf8')
    cur = database.cursor()
    value_list = []
    for row in rows:
        c_values = []
        for c in row:
            if c.value is None:
                c.value='NULL'
            c_values.append(c.value)
        vaue_tuple = tuple(c_values)
        value_list.append(vaue_tuple)
    print(value_list)
    c = len(value_list[0]) # 获取一行数据的长度
    s_list = ["%s"]*c
    s_str = ",".join(s_list)
    sql = "INSERT INTO {} VALUES({});".format(table_name,s_str)
    print(sql)
    cur.executemany(sql,value_list)
    database.commit() # 数据改动生效
    cur.close()
    database.close()