如下所示：

from openpyxl import workbookfrom openpyxl import load_workbookfrom openpyxl import worksheetdef find_false_in_sheet(sheet): for column in sheet.iter_cols():  for cell2 in column:   if cell2.value is not None:    # print cell2.value    # print type(cell2.value)    info2 = cell2.value.find('false')    if info2 == 0:     print cell2     print cell2.valuedef find_false_in_xlsx(file_name): print file_name wb = load_workbook(file_name) 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))  find_false_in_sheet(sheet)# startfind_false_in_xlsx("test.xlsx")# 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

以上這篇Python openpyxl 遍歷所有sheet 查找特定字符串就是小編分享給大家的全部?jī)?nèi)容了，希望能給大家一個(gè)參考，也希望大家多多支持武林站長(zhǎng)站。