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

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

2021-04-27 00:47lysaausb1 Python

今天小编就为大家分享一篇Python openpyxl 遍历所有sheet 查找特定字符串的方法，具有很好的参考价值，希望对大家有所帮助。一起跟随小编过来看看吧

如下所示：

				?

									from openpyxl import workbook

									from openpyxl import load_workbook

									from openpyxl import worksheet

									def 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.value

									def 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)

									# start

									find_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