利用Selenium和C#下载Excel文件

using OpenQA.Selenium;
using OpenQA.Selenium.Chrome;
using System;
using System.IO;

class Program
{
    static void Main()
    {
        // 设置 Chrome 驱动路径
        string chromeDriverPath = @"C:\path\to\chromedriver.exe";
        ChromeOptions options = new ChromeOptions();
        options.AddUserProfilePreference("download.default_directory", @"C:\path\to\download\folder");
        options.AddUserProfilePreference("download.prompt_for_download", false);
        options.AddUserProfilePreference("plugins.always_open_pdf_externally", true);

        using (IWebDriver driver = new ChromeDriver(chromeDriverPath, options))
        {
            // 打开目标网页
            driver.Navigate().GoToUrl("http://example.com/download-excel");

            // 找到下载按钮并点击
            IWebElement downloadButton = driver.FindElement(By.Id("downloadButtonId"));
            downloadButton.Click();

            // 等待文件下载完成
            System.Threading.Thread.Sleep(5000); // 简单等待，实际应用中应使用更可靠的等待机制

            // 验证文件是否下载成功
            string downloadPath = @"C:\path\to\download\folder";
            string[] files = Directory.GetFiles(downloadPath, "*.xlsx");
            if (files.Length > 0)
            {
                Console.WriteLine("文件下载成功: " + files[0]);
            }
            else
            {
                Console.WriteLine("文件下载失败");
            }
        }
    }
}