import xlrd
def extract(inpath):
data = xlrd.open_workbook(inpath, encoding_override="utf-8")
table = data.sheets()[0] # 选定表
nrows = table.nrows # 获取行号
ncols = table.ncols # 获取列号
all_info =[]
teacher = getnew(inpathnew)
print(teacher)
# print(nrows)
for i in range(0, nrows): # 第0行为表头
if i == 10:
break
else:
alldata = table.row_values(i) # 循环输出excel表中每一行,即所有数据
result = alldata[0] + "、" + alldata[1] + "、" + alldata[2] + "、" + alldata[3] + "、" + alldata[4] # 取出表中第二列数据
name = "刘诗诗"
data = name in result
if data:
index = i
same_name = name
#print(result)
def getnew(inpathnew):
data = xlrd.open_workbook(inpathnew, encoding_override="utf-8")