代码如下:
# -*- coding: utf-8 -*-
import pymysql
import xlrd
# 连接数据库
try:
db = pymysql.connect(host="127.0.0.1",
user="root",
passwd="root",
db=" test",
charset='utf8')
except:
print("could not connect to mysql server")
def open_excel():
try:
book = xlrd.open_workbook("user.xlsx")
# 文件名,把文件与py文件放在同一目录下;当其不与此脚本在同一目录下时,需要写上其绝对路径
try:
sheet = book.sheet_by_name("Sheet1")
return sheet
except:
print("locate worksheet in excel failed!")
except:
print("open excel file failed!")
def insert_deta():
sheet = open_excel()
cursor = db.cursor()
row_num = sheet.nrows
print(row_num)
# 第一行是标题名,对应表中的字段名所以应该从第二行开始,计算机以0开始