如何触发网页HTML按钮点击？自动化Excel下载链接问题求助

Hey Laurent, let’s break down why that #communicatie_export_users_xlsx anchor isn’t working, and walk through actionable ways to automate your Excel download task.

First, Why the Anchor Link Fails #

Anchor links (#some-id) only scroll the page to an element with a matching id attribute—they don’t trigger click events. That Excel download button is almost certainly powered by JavaScript: when you click it, it runs code to either fetch the export file from a backend API or generate it client-side, rather than linking directly to a file URL. Your anchor might even be pointing to a non-existent element (double-check the page source for an element with id="communicatie_export_users_xlsx"—it might not exist at all!).

Solutions to Automate the Download #

1. Grab the Direct Export API Endpoint

This is the cleanest approach if you can find it:

• Open your browser’s DevTools (F12), go to the Network tab.
• Manually click the "Exporteer ..." button under Communicatie.
• Look for a network request labeled something like export-users.xlsx, api/export/communicatie, or similar (check XHR/Fetch tabs if it’s an API call).
• Copy the full URL of that request (right-click > Copy > Copy link address).
• Now you can directly call this URL in your automation script (or even in a browser tab, if it doesn’t require dynamic auth tokens) to trigger the download. Just make sure you’re logged in (your browser will carry over session cookies) or include any necessary auth headers/tokens if you’re using a script.

2. Simulate the Click with Automation Tools

If you can’t isolate the API endpoint, use tools like Playwright or Selenium to mimic human interaction:

Example with Playwright (JavaScript):

const { chromium } = require('playwright');

(async () => {
  const browser = await chromium.launch({ headless: false }); // Keep headless: true for background runs
  const page = await browser.newPage();
  
  // Log in first if needed (add your login steps here)
  await page.goto('https://mysite.be/login');
  await page.fill('#username', 'your-username');
  await page.fill('#password', 'your-password');
  await page.click('text=Log in');

  // Navigate to the target page
  await page.goto('https://mysite.be/page');
  
  // Click the Communicatie menu to reveal the export option
  await page.click('text=Communicatie');
  
  // Wait for and click the export button
  await page.click('text=Exporteer ...');
  
  // Wait for the download and save it
  const download = await page.waitForEvent('download');
  await download.saveAs('communicatie-users.xlsx');
  
  await browser.close();
})();

Example with Selenium (Python):

from selenium import webdriver
from selenium.webdriver.common.by import By
from selenium.webdriver.support.ui import WebDriverWait
from selenium.webdriver.support import expected_conditions as EC

# Initialize the browser
driver = webdriver.Chrome()

# Log in (adjust selectors to match your site)
driver.get("https://mysite.be/login")
WebDriverWait(driver, 10).until(EC.presence_of_element_located((By.ID, "username"))).send_keys("your-username")
WebDriverWait(driver, 10).until(EC.presence_of_element_located((By.ID, "password"))).send_keys("your-password")
driver.find_element(By.XPATH, "//button[text()='Log in']").click()

# Navigate to the target page
driver.get("https://mysite.be/page")

# Open the Communicatie menu
WebDriverWait(driver, 10).until(EC.element_to_be_clickable((By.LINK_TEXT, "Communicatie"))).click()

# Click the export button
WebDriverWait(driver, 10).until(EC.element_to_be_clickable((By.LINK_TEXT, "Exporteer ..."))).click()

# Wait for download to complete (adjust timeout as needed)
driver.implicitly_wait(20)

driver.quit()

3. Check for Session/Auth Requirements

Whichever method you use, make sure your automation maintains the user session. If the site uses cookies for authentication, tools like Playwright/Selenium will automatically handle this if you log in first. If you’re calling the API directly, you’ll need to copy the session cookie from your browser and include it in your request headers.

内容的提问来源于stack exchange，提问作者Laurent Veys