读取表格使用pandas
import pymysql
import pandas as pd
#这个是表格的路径
filepath =r'C:\Users\22053\Desktop\总部\同学信息\学生信息采集表.xlsx'
connect = pymysql.connect('localhost','root','root','data_2')
cursor= connect.cursor()
#使用pandas读取表格内容
data = pd.read_excel(filepath)
xuehao = data['学号']
name = data['姓名']
sfz = data['身份证号']
#创建表格,并创建表格里面的选项
cursor.execute("CREATE TABLE IF NOT EXISTS Writer_4(Id INT PRIMARY KEY AUTO_INCREMENT,xuehao VARCHAR(30),name VARCHAR(30),sfz varchar(30))")
#将数据插入进表格,注意values的内容格式是元组
sql = "insert into writer_4(xuehao,name,sfz) values ('%s','%s','%s')"
for i in range(len(xuehao)):
cursor.execute(sql%(xuehao.values[i],name.values[i],sfz.values[i]))
connect.commit()
connect.close()