xlrd库的使用

book = xlrd.open_workbook('1.xlsx')#打开Excel文件
for sheet in book.sheets():#遍历Excel文件中的Sheet
    print(sheet.name)
sheet = book.sheet_by_index(0)#根据index打开sheet
sheet = book.sheet_by_name('Sheet1')#根据sheet名字打开对应的表格
sheet.nrows#sheet的总行数
sheet.ncols#sheet的总列数
for i in range(sheet.nrows):#遍历每一行数据
    for cell in sheet.row_values(i):
        if cell != '':
            print(cell)