import os
import requests
from lxml import etree
from openpyxl import Workbook

# 发送HTTP请求获取网页内容
response = requests.get("https://www.baidu.com")

# 解析网页内容
html = etree.HTML(response.text)

# 使用XPath表达式提取需要的数据
results1 = html.xpath("html/body/div/div/a/div/div/div/img")
results2 = html.xpath("html/body/div/div/div/div/div/a/div/div/img")

# 获取桌面路径
desktop_path = os.path.join(os.path.expanduser('~'), 'Desktop')

# 创建Excel工作簿
workbook = Workbook()
sheet = workbook.active

# 将结果写入Excel文件的第一列和第二列
for i, (result1, result2) in enumerate(zip(results1, results2), start=1):
    sheet.cell(row=i, column=1, value=result1)
    sheet.cell(row=i, column=2, value=result2)

# 保存Excel文件到桌面
output_file = os.path.join(desktop_path, 'output.xlsx')
workbook.save(output_file)