如何循环从href下载excel(当所有文件的href都相同时)

import requests
from bs4 import BeautifulSoup

# 发送HTTP请求获取网页内容
response = requests.get('http://example.com')
html = response.text

# 使用BeautifulSoup解析网页内容
soup = BeautifulSoup(html, 'html.parser')

# 提取所有Excel文件的href链接
excel_links = []
for link in soup.find_all('a'):
    href = link.get('href')
    if href.endswith('.xlsx') or href.endswith('.xls'):
        excel_links.append(href)

# 循环下载Excel文件
for link in excel_links:
    # 发送HTTP请求下载Excel文件
    excel_response = requests.get(link)
    
    # 保存Excel文件
    with open(link.split('/')[-1], 'wb') as file:
        file.write(excel_response.content)