#读取excel数据
# 打开文件
data = xlrd.open_workbook('E:\桌面\demo.xlsx')
table = data.sheet_by_index(0)
# 获取总行数
nrows = table.nrows
# 获取总列数
ncols = table.ncols
# 获取一列的数值,例如第4列
four = table.col_values(3)
# 获取一列的数值,例如第8列
six = table.col_values(7)
j=0
h=0
k=0
p=0
q=0
for j in range(nrows):
a = four[j]
b = six[j]
if a == "待修复" and b =="细微":
h += 1
elif a == "待修复" and b =="一般":
k += 1
elif a == "待修复" and b =="严重":
p &