Python openpyxl 遍历所有sheet 查找特定字符串的方法
如下所示:
fromopenpyxlimportworkbook fromopenpyxlimportload_workbook fromopenpyxlimportworksheet deffind_false_in_sheet(sheet): forcolumninsheet.iter_cols(): forcell2incolumn: ifcell2.valueisnotNone: #printcell2.value #printtype(cell2.value) info2=cell2.value.find('false') ifinfo2==0: printcell2 printcell2.value deffind_false_in_xlsx(file_name): printfile_name wb=load_workbook(file_name) all_sheets=wb.get_sheet_names() print(all_sheets) foriinrange(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") #forrowinsheet.iter_rows(): #forcellinrow: #ifcell.valueisnotNone: #info=cell.value.find('BB') #ifinfo==0: #printcell.value
以上这篇Pythonopenpyxl遍历所有sheet查找特定字符串就是小编分享给大家的全部内容了,希望能给大家一个参考,也希望大家多多支持毛票票。