xlrd读取Excel数据

import xlrd

xls = 'bug.xls'
sheet =xlrd.open_workbook(xls).sheets()[0]
#获取bug总数
bug_num = sheet.nrows-1

#获取bug提交人
sub = sheet.col_values(20)
#bug提交人去重复
bug_submit = [str(i) for i in set(sub[1:])]

#获取bug严重等级
levels = [int(p) for p in sheet.col_values(8)[1:]]
bug_level = [int(o) for o in set(levels)]
bug_level1 = ['level '+str(int(o)) for o in set(levels)]

#查询bug等级对应的数目
a = [];b = [];c = [];d = []
for n in levels:
    if n == bug_level[0]:
        a.append(n)
    elif n == bug_level[1]:
        b.append(n)
    elif n == bug_level[2]:
        c.append(n)
    else:
        d.append(n)

#把不同等级的bug列表数目找出来
x = []
def get_bugs():
    x.append(len(a));x.append(len(b));x.append(len(c));x.append(len(d))
    return x