从excel文档导入数据标题，使用pandas搜索web，然后导出到同一excel文档中的特定行/列。

import pandas as pd
import openpyxl
import requests

df = pd.read_excel('input.xlsx')

filtered_df = df.loc[df['标题'].str.contains('web')]

writer = pd.ExcelWriter('output.xlsx', engine='openpyxl')

filtered_df.to_excel(writer, sheet_name='Sheet1', startrow=1, startcol=1, index=False)

writer.save()
writer.close()

import pandas as pd
import openpyxl

# 读取excel文档
df = pd.read_excel('input.xlsx')

# 筛选包含关键词"web"的行
filtered_df = df.loc[df['标题'].str.contains('web')]

# 创建excel写入器对象
writer = pd.ExcelWriter('output.xlsx', engine='openpyxl')

# 将筛选后的数据写入到指定的行/列
filtered_df.to_excel(writer, sheet_name='Sheet1', startrow=1, startcol=1, index=False)

# 保存并关闭excel写入器对象
writer.save()
writer.close()