python_excel_openpyxl_成功实现遍历表格并取得数字

from openpyxl import load_workbook



wb = load_workbook("test.xlsx")
all_sheets = wb.get_sheet_names()
print(all_sheets)

for i in range(len(all_sheets)):
    sheet = wb.get_sheet_by_name(all_sheets[i])
    print(sheet.title + ': max_row: ' + str(sheet.max_row) + ' max_column: ' + str(sheet.max_column))

sheet = wb.get_sheet_by_name(all_sheets[0])
for row in sheet.iter_rows():
    for cell in row:
        if cell.value is not None:
            info = cell.value.find('BB')
            if info == 0:
                print(cell.value)