Python根据关键字在Excel工作表中搜索行并返回该行

import pandas as pd
from openpyxl import load_workbook

df = pd.read_excel('file.xlsx', sheet_name='Sheet1')

keyword = '关键字'
filtered_df = df[df['列名'].str.contains(keyword, case=False)]

result = filtered_df.values.tolist()

book = load_workbook('file.xlsx')
writer = pd.ExcelWriter('file.xlsx', engine='openpyxl') 
writer.book = book
writer.sheets = dict((ws.title, ws) for ws in book.worksheets)
filtered_df.to_excel(writer, sheet_name='Sheet1', index=False, header=False, startrow=len(df)+1)
writer.save()