Python3 Excel文档数据写入Mysql

from openpyxl.reader.excel import load_workbook as lw

import mysql.connector as mc

conn = mc.connect( user= 'root', password= 'root', host= '127.0.0.1', database= 'test2')

cur = conn.cursor()

insert_sql = 'insert into dd (dp,dps,dpt,name,num) values ( %s , %s , %s , %s , %s )'

wb = lw( filename = 'c: \\ Users \\ Administrator \\ Desktop \\ qwe.xlsx')

ws = wb.get_sheet_by_name(wb.get_sheet_names()[ 0]) # <worksheet "data">

rows = ws.max_row # 最大行数

columns = ws.max_column # 最大列数

data = []

for rx in range( 2, rows+ 1):

for cx in range( 1, columns+ 1):

data.append( str(ws.cell( row=rx, column=cx).value))

cur.execute(insert_sql, (data[ 0], data[ 1], data[ 2], data[ 3], data[ 4]))

data = []

conn.commit() # 提交

# 关闭两个连接

cur.close()

conn.close()