python_excel_openpyxl模糊查询excel中某个单元格的位置

from openpyxl import load_workbook


def search_value(filename,keyword):
    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_rows():
        for cell in row:
            if cell.value is not None:
                info = cell.value.find(keyword)
                if info == 0:
                    print(cell.value)
                    print(cell.row)
                    print(cell.column)




if __name__ == '__main__':

    try:
        filename='test.xlsx'
        keyword='存货'
        search_value(filename,keyword)
        print('   Finish')
    except Exception as e:
        print(e)