[µo°Ý] ¥ÎSelenium §ì¤W¥«¦æ±¡§Y®É¸ê®Æ ???

t8899

https://mis.twse.com.tw/stock/gr ... type=all&ind=01
§Ú·Q§ì¤W¥«©Ò¦³ÃþªÑ¦æ±¡¶×¤Jexcel  (¥k¤U¨¤ªº­¶¼Æ§ì©Ò¦³ªº­¶¼Æ)
³o­Óºô­¶¦n¹³¥i¥H¥Îºô­¶¦ì§}«á­±ªº°Ñ¼Æ§ì¤£¦Pªº¸ê®Æ?³o­n±q¦ó³B¬Ý¤~¯à±o¨ì·Q­nªº¸ê®Æ?
§Ú¥u¬Ý¨ìind=01==>¤ôªd ¦UÃþ§Oªº¸¹½X ¡A¬O§_¦³§ì¥þ³¡Ãþ§Oªº¸¹½X?¡A­¶¼Æ¥i§_¤@¦¸§ì©Ò¦³??

t8899

¦^´_  t8899

chromeDriveªºÀɮפU¸üºô§}§ï¤F

­n§ï¤U­±¨º­Ó
'download_url = "https://edgedl.me.gv ...
singo1232001 µoªí©ó 2024-2-23 18:38

ÁÂÁ§iª¾

singo1232001

¦^´_ 62# t8899

chromeDriveªºÀɮפU¸üºô§}§ï¤F

­n§ï¤U­±¨º­Ó
'download_url = "https://edgedl.me.gvt1.com/edgedl/chrome/chrome-for-testing/" & version_number & "/win64/chromedriver-win64.zip"
download_url = "https://storage.googleapis.com/chrome-for-testing-public/" & version_number & "/win64/chromedriver-win64.zip"

t8899

[quote]¦^´_  t8899


    ¤@­Ó¤£ºâbugªº¤pbug¦^³ø »Ý­nª`·N¤@¤U

¹J¨ìªºª¬ªp
·íchrome119ª©®É  ¦ý chromed ...
singo1232001 µoªí©ó 2023-11-8 12:08 [/quot
·PÁ´£¿ô¡A¤]ÁÂÁ±zªº«ü¾É

singo1232001

¦^´_ 59# t8899


    ¤@­Ó¤£ºâbugªº¤pbug¦^³ø »Ý­nª`·N¤@¤U

¹J¨ìªºª¬ªp
·íchrome119ª©®É  ¦ý chromedriver ÁÙ°±¯d¦b 118ª©¨Ã¨S¦³§ó·s

­ì¦]¦b©ó
¤§«eª©¥»¤£¦P®É chromedriver·|§¹¥þµLªk¶}±Òchrome ¨Ã¶i¤Jupdateselenium¦Û°Ê§ó·sµ{§Ç

¦ý²{¦bª©¥»¤£¦P®É "¤@¼Ë¯à±Ò°ÊÂsÄý¾¹,¦ý·|¥X²{¤@¨Çºô­¶¤¸¯ÀµLªkfindÀò¨ú¸òÂIÀ»ªºbug" ¨Ò¦p¼u¥XÃþ«¬ªº ©ÎªÌ javascriptÃþ«¬ªº °ÊºA¥Í¦¨¤¸¯À
·|µLªk¥¿½T¾Þ§@

©Ò¥H§Ú­Ì»Ý­n¼W¥[¤@¨Ç§PÂ_¨Ã call updateselenium ³o¬q¥\¯à  
¥²¶·¦b¦U¦ì¦Û¤v¼gªº¥Dµ{§Ç¤¤ ¥h·s¼W§PÂ_¬O§_­n­«·sÀˬd ÂsÄý¾¹»P´¡¥óªºª©¥»¸¹
¨Ò¦p:­«·s¶}±Ò¦¸¼Æ¹L¦h ©ÎªÌ¥¢±Ñ¶W¹L´X¦¸ ¥²¶· call updateselenium

§Ú¥Ø«e¹J¨ìªº¬O ÂsÄý¾¹¥¿±`¶}±Ò  ¦ý¬Y­Ó¤¸¯À»P«ö¶sÂI¤£¤U¥h
§Ú¼W¥[¤@¨Ç¥¢±Ñ¿ù»~¦¸¼Æ§PÂ_  °ÝÃD¤w¸Ñ¨M ¦Ó¤§«e´£¨Ñªº§ó·sµ{§Ç ¤£»Ý­n­×§ï

singo1232001

¦^´_ 59# t8899


    1. ¥i¥H  ©ÎªÌ¦Û¤v³]­ÓPATH3 ,¦ADIR °µ§PÂ_
2.­Y¤£¼vÅT  ¨º´N©ñµÛ¤£ºÞ¥L´N¦n À³¸Ó¬O§Ú¨S¼g§R°£ZIPªº¥\¯à

t8899

¦^´_ 52# singo1232001
path1 = "C:\Users\" & Environ$("username") & "\AppData\Local\SeleniumBasic\Chromedriver.exe"
1.§Ú¬O¸Ë¦b¤W­±ªº¸ê®Æ§¨?¨S§ì¨ì?§Ú´N§â"C:\Users\" & Environ$("username") & "ª½±µ´«¦¨¹ê»Úªº¸ô®|¤~§ì¨ì ?
2.¤U¸ü¦³¦¨¥\, ¤]¦³¸ÑÀ£ÁY¡A¦ýzipÀɨS§R°£ ?

Scott090

¦^´_ 57# singo1232001


    ¦³±o¨ì¥¿½Tªº¸ê®Æ¤F¡G
         ®É¶¡ =  "¸ê®Æ®É¶¡:2023/08/21 14:30"

    «D±`·P®¦

singo1232001

¦^´_ 56# Scott090

Driver.Get "https://tw.stock.yahoo.com/quote/1101.TW"

   Do: Set ID0 = Driver.findelementsbyID("main-0-QuoteHeader-Proxy")
        If ID0.Count > 0 Then Exit Do
        Loop
   Do: Set spans = ID0(1).findelementsbytag("span")
        If spans.Count > 0 Then Exit Do
        Loop
    For Each Z In spans
    If Z.Text Like "*½L*§ó·s*" Then
    sp = Split(Z.Text, " ")
    ®É¶¡ = "¸ê®Æ®É¶¡:" & sp(2) & " " & sp(3)
    Exit For
    End If
    Next

Scott090

¦^´_ 55# singo1232001

  ¸g´ú¸Õ«á¡A ®É¶¡ÅܼƬOªÅ¥Õ¡A ¤£ª¾°ÝÃD¦b­þ¸Ì
  ½Ð ¤j¤j ¦A¬Ý¬Ý
  ÁÂÁÂ