Python Excel找出某一行整行为空的那一行

workbook = xlrd.open_workbook(filename='D:/Users/Administrator/Desktop/PY文件/新建 Microsoft Excel 工作表.xlsx')

sheet_names = workbook.sheet_names()

for sheet_name in sheet_names:
    sheet = workbook.sheet_by_name(sheet_name)
    hs = sheet.nrows
    ls = sheet.ncols
    # print(str(hs) + '行')
    a = []
    for x in range(ls):
        a.append('')
    for curr_row in range(0, hs):
        if sheet.row_values(curr_row) == a:
            print('是', sheet.row_values(curr_row))
        else:
            print('不', sheet.row_values(curr_row))

  

 

posted @ 2020-09-15 09:05  德国的本  阅读(914)  评论(1)    收藏  举报