jidawanghao的专栏

from openpyxl import load_workbook def search_value(filename,keywor,compare_mode): wb = load_workbook(filename) all_sheets = wb.get_sheet_names() print(all_sheets) sheet = wb.get_sheet_by_name(all_sheets[0]) for row in sheet.iter_row.