准备Excel(test.xlsx)
导库
import pymysql
import xlrd
完整代码
import pymysql
import xlrd
def connect_database(dataname,user,password):
db = pymysql.connect(host='127.0.0.1',port=3306,user=user,passwd=password,db=dataname, charset='utf8')
return db
def read_excel(url):
workbook = xlrd.open_workbook(r''+url)
# 获取所有sheet
workbook.sheet_names()
# 获取 第一个 sheet
sheet1_name = workbook.sheet_names()[0]
print("第一个Sheet名称:"+sheet1_name)
# 根据sheet索引或者名称获取sheet内容
sheet1 = workbook.sheet_by_name('Sheet1')
# sheet的名称,行数,列数
# rows =