此程序是用来将表格的数据读入到数据库中

import xlrd import re import pymysql

def read_xlsx(): workbook = xlrd.open_workbook('author.xlsx') booksheet = workbook.sheet_by_name('Sheet1') j = 0 for i in range(0,booksheet.nrows):#按照行来读的 #print(booksheet.row_values(i)[0],booksheet.row_values(i)[1],booksheet.row_values(i)[2]) t1=booksheet.row_values(i)[0] t2=booksheet.row_values(i)[1] t3=booksheet.row_values(i)[2] print("-------------------------------------------") try: conn = pymysql.connect(host='localhost', port=3306, user='*', password='*', database='**', charset='UTF8') cur = conn.cursor() except: print("连接数据库失败") try: sql ="insert into authors (nm, addr, email) values (%s, %s, %s)" cur.execute(sql,(t1,t2,t3)) conn.commit() j = j + 1 except :

print('insert roadky failed ')
        continue
 
print("共插入%d"% j)
conn.commit()
conn.close()

if name == 'main': read_xlsx()