代码如下所示:
import pymysql
import xlrd
import xlwt
def get_conn():
conn = pymysql.connect(
host=‘’,
port=,
user='’,
passwd='’,
db=’***’,
charset=‘utf8’)
return conn
def insert(cur, sql, args):
cur.execute(sql, args)
def read_xlsx_to_mysql(filename):
excel = xlrd.open_workbook(filename) # 打开xlsx文件,返回一个对象
sheet = excel.sheet_by_index(0) # 获取第一个sheet表格
conn = get_conn()
cur = conn.cursor()
sql = ‘insert into h_test values(%s,%s,%s)’ # 数据库表名
print(sheet.nrows)
for row in range(sheet.nrows):
print(row)
args = sheet.row_values(row)
print(args)
print(type(args))
if row == 0:
continue
if args[1] is None or args[1] == ‘’:
continue
insert(cur, sql, args=args)
conn.commit()
cur.close()
conn.close()
if name == ‘main’:
read_xlsx_to_mysql(‘F:\cc.xlsx’)
成功导入表中