:
from openpyxl import load_workbook
加载工作簿
wb = load_workbook('example.xlsx')
选择工作表
sheet = wb['Sheet1']
遍历表格
for row in sheet.rows: for cell in row: # 找到指定字符串 if cell.value == '指定字符串': print('找到指定字符串:', cell.value)
:
from openpyxl import load_workbook
wb = load_workbook('example.xlsx')
sheet = wb['Sheet1']
for row in sheet.rows: for cell in row: # 找到指定字符串 if cell.value == '指定字符串': print('找到指定字符串:', cell.value)