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_rows(): for cell in row: if str(cell.value).find(keyword) != -1: print(cell.value) print(str(cell.value).find(keyword)) print(cell.row) print(cell.column) if __name__ == '__main__': filename='资产负债表.xlsx' keyword="存货" compare_mode="" search_value(filename,keyword,compare_mode) print('Finish')