ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

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

¦^´_  t8899

¦Û¿ï
y ¬Q¤é¦¬½L»ù
...
quickfixer µoªí©ó 2022-10-23 02:41


https://mis.twse.com.tw/stock/gr ... ind=TIDX#STATISTICS
½Ð±Ð§Ú·Q§ì¤W­±ºô­¶table 5 To 6  xmlhttpªº»y¥h?

TOP

¦^´_ 21# t8899


    Sub test56()

Set driver = CreateObject("Selenium.ChromeDriver")

driver.get "https://mis.twse.com.tw/stock/group.jsp?ex=tse&currPage=0&ind=TIDX&bp=0&type=fixed"

Set tbls = driver.findelementsbytag("table")

tbls(5).astable.toexcel Cells(1, 1)

tbls(6).astable.toexcel Cells(1, 10)
End Sub

TOP

¦^´_  t8899


    Sub test56()

Set driver = CreateObject("Selenium.ChromeDriver")

driver.g ...
singo1232001 µoªí©ó 2022-10-23 13:22


ÁÂÁÂ! §Ú¬O«ü xmlhttp ªº»yªk
¹ï¤F¡A«e­±¥S¥x¼gªºSelenium »yªk ¡A5871 ³o°¦ªÑ²¼Äæ¦ì¤£¹ï¡ASplit ªº°ÝÃD?
¥Î xmlhttp »yªk¬O¹ïªº¡C

TOP

¦^´_  t8899

¤@©w­nSelenium?
³o¸Ì§Û¨Óªºxmlhttp,³t«×§Ö¦h¤F
¤Þ¥Î¨Ó·½


¦Û¿ï
y ¬Q¤é¦¬½L»ù
...
quickfixer µoªí©ó 2022-10-23 02:41


§Ú­è´ú¸Õ¡A¶W¹L170°¦¡A´N¥X²{¿ù»~¤F
Snap1.jpg
2022-10-23 13:58

TOP

¥»©«³Ì«á¥Ñ singo1232001 ©ó 2022-10-23 18:08 ½s¿è

¥u¦³²Ä¤@¦¸°õ¦æ¤ñ¸û¤[ ¦]¬°¶}ÂsÄý¾¹
    ¦ý¤§«á³£¬O¬íŪ­ò ÂsÄý¾¹³£¦b­I´º¶}µÛ

seleniumdownload v5.zip (33.96 KB)

TOP

¥»©«³Ì«á¥Ñ t8899 ©ó 2022-10-23 20:18 ½s¿è
¥u¦³²Ä¤@¦¸°õ¦æ¤ñ¸û¤[ ¦]¬°¶}ÂsÄý¾¹
    ¦ý¤§«á³£¬O¬íŪ­ò ÂsÄý¾¹³£¦b­I´º¶}µÛ
singo1232001 µoªí©ó 2022-10-23 18:00

§Ú¥Î150°¦ ¦³¤@°¦3036 ¦³°ÝÃD
§Ú¥Î200°¦  ¿ù¦b  ReDim br(1 To UBound(sp) - 1, 0 To 50)  ??
³Ì¦h¥u¯à´X°¦?¤W¥«¥þ³¡¤j¬ù900¦h°¦

seleniumdownload v5.zip (93.03 KB)


Snap2.jpg
2022-10-23 20:14

TOP

³Ì¦h¥u¯à´X°¦?¤W¥«¥þ³¡¤j¬ù900¦h°¦
t8899 µoªí©ó 2022-10-23 20:15


§Ú¸Õ166¤ä¨S°ÝÃD,²Ä167¤ä´N¥X¿ù§ì¤£¨ì¸ê®Æ,§A¥i¯à­n¤À¦¸¤U¸ü

Image 008.png
2022-10-23 20:36

TOP

¥»©«³Ì«á¥Ñ quickfixer ©ó 2022-10-23 20:54 ½s¿è

¦^´_ 27# quickfixer


    ¶W¹L119¤ä«á­±ªºªÑ²¼´N¨S¸ê®Æ,¦ýµ{¦¡¥i¥H¶]§¹
²Ä167¤ä,ºô­¶¥X¿ù¨S¸ê®Æ,©Ò¥Hµ{¦¡¤]¸òµÛ¿ù
xmlhttp¡BSelenium ³£¤@¼Ë°ÝÃD,¬Oºô¯¸­­¨î

TOP

¦^´_ 28# quickfixer


    ¤j§ï
¥i¯à¦³«Ü¦hbug »Ý­n´ú¸Õ

seleniumdownload v6.zip (289.46 KB)

TOP

¦^´_  quickfixer


    ¤j§ï
¥i¯à¦³«Ü¦hbug »Ý­n´ú¸Õ
singo1232001 µoªí©ó 2022-10-23 22:53

À³¸Ó®t¤£¦h¤F
¦³ªº¥þªÅ¥Õ¡AÀ³¸Ó¬O¼È°±¥æ©ö¡A³o¬O¥¿±`
¥Î940°¦¥i¥H¥¿±`¶]§¹¡A³t«×·Pı¨SºC¦h¤Ö¡AÁÙ¬O¦³´X°¦¦³°ÝÃD??
seleniumdownload v6.zip (313.24 KB)

Snap1.jpg
2022-10-24 06:03

TOP

        ÀR«ä¦Û¦b : ¯à·F¤£·F¡A¤£¦p­W·F¹ê·F¡C
ªð¦^¦Cªí ¤W¤@¥DÃD