Python openpyxl 遍历所有sheet 查找特定字符串的方法

Python  /  管理员 发布于 7年前   502

如下所示：

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 查找特定字符串就是小编分享给大家的全部内容了，希望能给大家一个参考，也希望大家多多支持。