在Python中使用Selenium下载文件

Question

我正试图从一个包含阿根廷代表投票的公共网站自动下载excel文件。例如，来自以下页面:https://votaciones.hcdn.gob.ar/votacion/4108

我收到以下消息：

selenium.common.exceptions。ElementClickInterceptedException:消息：元素在点（229480）处不可单击，因为另一个元素使其模糊

如果我尝试通过< code > driver . execute _ script(' JavaScript:export excel()；'在页面内执行下载excel特定脚本)什么都不会发生。

有什么办法能让它工作吗？

Answer 1

下面是一个使用自动编辑器的示例。友情链接： https://www.autoitscript.com/forum/topic/153520-iuiautomation-ms-framework-automate-chrome-ff-ie/

#include <GUIConstantsEx.au3>
#include <TabConstants.au3>
#include <WindowsConstants.au3>
#include <MsgBoxConstants.au3>
#include <EditConstants.au3>
#include <WinAPIGdi.au3>
#include <WinAPIGdiDC.au3>
#include <WinAPIHObj.au3>
#include <WinAPISysWin.au3>
#include <AD.au3>
#include <Array.au3>
#include "UIAWrappers.au3"
#include <FileConstants.au3>
#include <WinAPIFiles.au3>
#include <GuiListBox.au3>
#include <Word.au3>
#include <File.au3>
#include <Excel.au3>


Opt("WinWaitDelay", 150)
Opt("WinTitleMatchMode", 2)
Opt("WinDetectHiddenText", 1)
Opt("MouseCoordMode", 2)
Opt("SendKeyDelay", 10)
Opt("GUIResizeMode", 1)
HotKeySet("^!x", "MyExit")

Global  $Web, $hWnd

$Web = "https://votaciones.hcdn.gob.ar/votacion/4108"

ShellExecute("C:\Program Files (x86)\Google\Chrome\Application\chrome.exe", "--new-window --force-renderer-accessibility " & $Web, "", "")
WinWait("DSE - Voto Electrónico - Google Chrome", "", 8)
$hWnd = WinGetHandle("DSE - Voto Electrónico - Google Chrome")
WinActivate($hWnd)
WinSetState($hWnd, "", @SW_MAXIMIZE)
Sleep(7000); Give time for the webpage to load (out of country)

Local $oP6=_UIA_getObjectByFindAll($UIA_oDesktop, "Title:=DSE - Voto Electrónico - Google Chrome;controltype:=UIA_PaneControlTypeId;class:=Chrome_WidgetWin_1", $treescope_children)
_UIA_Action($oP6,"setfocus")
Local $oP5=_UIA_getObjectByFindAll($oP6, "Title:=DSE - Voto Electrónico;controltype:=UIA_DocumentControlTypeId;class:=Chrome_RenderWidgetHostHWND", $treescope_children)
_UIA_Action($oP5,"setfocus")

;~ First find the object in the parent before you can do something
Local $oUIElement=_UIA_getObjectByFindAll("XLSX.mainwindow", "title:=XLSX;ControlType:=UIA_HyperlinkControlTypeId", $treescope_subtree)
Local $oUIElement=_UIA_getObjectByFindAll($oP5, "title:=XLSX;ControlType:=UIA_HyperlinkControlTypeId", $treescope_subtree)
_UIA_Action($oUIElement, "setfocus")
_UIA_Action($oUIElement, "highlight")
_UIA_Action($oUIElement, "activate")
_UIA_Action($oUIElement, "leftclick")

Func MyExit()
    Exit
EndFunc   ;==>MyExit

Answer 2

最后，我可以完成它。我使用了本页中提出的程序。但必须通过< code > options . set _ preference(" browser . helper apps . never ask . savetodisk "，" application/octet-stream，application/vnd . ms-excel ")指令更改< code > options . set _ preference(" browser . helper apps . never ask . savetodisk "，" application/vnd . openxml formats-office document . spreadsheetml . sheet ")。

工作示例是：

from selenium import webdriver
from selenium.webdriver.firefox.options import Options

options = Options()
options.set_preference("browser.download.folderList",2)
options.set_preference("browser.download.manager.showWhenStarting", False)
options.set_preference("browser.download.dir","/data")
options.set_preference("browser.helperApps.neverAsk.saveToDisk", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet")

with webdriver.Firefox(options=options) as driver:
    
    driver.get('https://votaciones.hcdn.gob.ar/votacion/4108')
    driver.execute_script('javascript:exportExcel();')

Answer 3

你需要点击下载按钮，然后使用Autoit或其他ui自动工具自动创建下载对话框。