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)