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

[µo°Ý] Ãö©óºô­¶¸ê®Æ§ì¨ú°ÝÃD

¦^´_ 1# sujane0701

¥i¥ÎPythonªºRequests»PBeautifulSoup¼Ò²Õ¹F¦¨¥Øªº¡A¥H¤U¼v¤ù¬O½d¨Ò¡A¥i²z¸Ñ«áÀ³¥Î
https://www.youtube.com/watch?v=Ef0kh6NPiBE&t=9s
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

¥»©«³Ì«á¥Ñ VBALearner ©ó 2017-2-7 14:52 ½s¿è

¦^´_ 3# sujane0701

±z¬O­ÓªÖ¾Ç²ßªº¤H¡A¦AÀ°§A¤@¨Ç! ªþ¹Ï¬O§Ú¥ÎPython3¼gªºµ{¦¡©Ò§ì¥X¨Óªº¸ê®Æ¡A³o­Ó°Ê§@¥u¦³¬d¸ß¥D´£³æªº¥D­n¸ê®Æ¡C§ó¸Ô²Óªº¸ê®Æ(¹³¬O³f«~¦WºÙ¡B¤é´Áµ¥)­n¦A°µ²Ä¤G¦¸³X°Ý°Ê§@¡A´Nµ¥©ó¬O§A¦b¥D´£³æ¬d¸ß­¶­±¤W¿é¤J¥D´£³æ¸¹½X¬d¤F²Ä¤@¦¸¡Aµ¥µ²ªG¥X¨Ó«á¦AÂIÀ»¥D´£³æ³sµ²¶i¦æ²Ä¤G¦¸³X°Ý·j´M±z­nªº¥þ³¡¸ê®Æ¡C
µ{¦¡¶·ª`·Nªº²Ó¸` :
1.Requests.Session()¡A¬O¬°¤F«O¯dµn¤J»{ÃҥΪºCookie¡A¥i¥H¤WºôGoogle¾Ç²ß
2.¸Óµ{¦¡»Ý­n¨â­Ó«D¤º«Øªº¤½¶}¼Ò²Õ¡A¦w¸Ë§¹Python3«á¦A¦Û¦æ¦w¸ËRequests¡BBeautifulSoup4¼Ò²Õ¡A¦w¸Ë¤èªk(ex: Pip install)¥i¤WºôGoogle¾Ç²ß
²Ä¤G¦¸ªºPOST´N¥ý¯dµ¹±z¸Õ¸Õ¬Ý¡A§¹¦¨ªº¸Ü´N¥i¥H¼¶¼g¦¨°j°é¡A¥H¹F¨ì­«½Æ¦h¦¸¬d¸ß¨Ã¦s¨ú¸ê®Æªº¥Øªº! (PS : Time¼Ò²Õ¥Ø«e¼È®É¤£¶·¨Ï¥Î¡A¦ý­«½Æ¬d¸ßªº°Ê§@¥i¯à·|³Qµø¬°´c·Nµ{¦¡¡A©Ò¥H¥¼¨Ó¥i¯à·|»Ý­n¥Î¨Ó´î§Cµ{¦¡±K¶°ªº³X°ÝÀW²v)
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

¦^´_ 6# sujane0701

Python¸òVBA¬O¨âºØ¤£¦Pªº»y¨¥¡AVBA¤ñ¸û¹³¬OEXCEL±MÄݪºª«¥ó»y¨¥¡A©Ò¥HVBA¦b³B²z«DEXCEL¤º«Ø¥\¯àªº°ÝÃD¤W´N¦³³\¦h¤£¨¬¡A¦ý¤]¦]¬°¥\¯à³£focus¦bEXCEL¤W¡A¤]¤ñ¨ä¥L»y¨¥¦n¾Ç³\¦h¡A»{¯u¾Çªº¸Ü¡A¤@­Ó¤ë¤£¨ì´N¥i¥H¾Ç§¹9¦¨ªº»yªk+À³¥Î¡C§Ú¤@¶}©l¤]¬O±qVBA¾Ç°_¡A·Q·íªìÁÙ­A¥ô©Ê¨Dª©¤jÀ°§Ú¤É¯ÅxD¡A«á¨Óµo²{Python¦b§ìºô¸ô¸ê®Æ§ó§Ö¡B§ó¤è«Kªº®É­Ô¡A§Ú´N²¾±¡§OÅʤF¡A¦³ÃöVBA¥hPOSTºô­¶ªºµ{¦¡§Ú¤ñ¸û¤£¼ô¡A³o¥i¯à­n°ÝVBA°ª¤â­Ì¤ñ¸û¦X¾A : GBKEE¡Bc_c_lai¡B­ã´£¥¬ªL...
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

¦^´_ 6# sujane0701

¹ï¤F¡A­n"ª¦ÂÎ"­n¾Ç·|¬ÝÀ´ºô­¶­ì©l½X(HTML)³á
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

¦^´_ 10# sujane0701

ª¦ÂΪºª¾ÃÑ­n¾a¦Û¤v¤@ÂI¤@ºwºCºC¥h¤Ñ¤ÑºN¡A¤Ñ¤Ñ²Ö¿n¡A³Ì­«­nªº¬O¡A¹J¨ì°ÝÃD­n¯à¦b"GOOGLE·j´M"§äµª®×¡A«e¤H©Ò²Ö¿nªºª¾Ãѳ£¦s¦b©óºô¸ô³o­Ó¤j¸ê®Æ®w¸Ì¡A¤p§Ì§Ú¤]¬O¯¸¦b¥¨¤HªºªÓ»H¤W¾Ç²ß¡Cµ¥±z¤j·§¬ÝÀ´HTMLªº¥D­n¼ÐÅÒ(±`¥Îªº´N¦n¡A¤£­n¹d²ÓÃû¿òªº­I)¡A¨Ã¯à°÷²z¸Ñ¦p¦ó¥ÎPython¡BChromeªº¶}µo¤H­û¤u¨ã¹ê²{POST°Ê§@«á¡A±z´N¥i¥H§ï§Úªºµ{¦¡½X¥h°µ²Ä¤G¦¸POST°Ê§@¡AÀò¨ú±z³Ì²×­nªº¸ê®Æ¤F¡A¦A°t¦Xxls®M¥ó§â¸ê®Æ¦sÀɧY¥i¡C¥H¤Uªþ¹Ï´£¥Ü²Ä¤G¦¸POSTªº°Ñ¼Æ©Ò¦b¦ì¸m¡A¦³ÃöPython¤£À´ªº»yªkGOOGLE¤@¤U§Y¥i±oª¾¡A¦³°ÝÃDÅwªï¦A´£¥X¡A¥[ªo!!!
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

¦^´_ 10# sujane0701

²Ä¤G¦¸POST©Ò»Ý°Ñ¼Æ¦p¹Ï¡A¥ÎChromeªº¶}µo¤H­û¤u¨ãÆ[¹î§Y¥i±oª¾POSTªº©Ò»Ý¸ê°T
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

¦^´_ 12# VBALearner

µo²{¤Ö®Ø¨â­Ó°Ñ¼Æ...
¨ä¹ê¥i¥H¤£¥ÎPOST¤èªk¡A¥Î­ì©l½Xµ¹ªº¤wªþ¥[°Ñ¼Æªººô§}GET¤]¥i¥H
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

¦^´_ 14# c_c_lai

c¤j¡A¤£¦n·N«ä¡A³o¬O§Úªº¿ùxD
§Ú¨S¦³POµ{¦¡½X³y¦¨±zªº¤â°Ê¿é¤J¿ù»~...¯u¬O©êºp«¢«¢«¢
Å]°­Âæbºô§}ªº²Ó¸`¸Ì«¢«¢«¢

Hint : I¸òLÁÙ¯u¹³ªü¨þ¨þ
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

¦^´_ 16# c_c_lai

§Úµo²{¬Q¤ÑPO¹Ï®É¥´¿ù¤Fºô§}ªº¶¶§Ç¤F¡A§Ú§â§Aªº¥´¦¨§Úªº...¥¿½T¬O"¤j¼gi"¤~¹ï......= ="
ªþ­ì©l½X¡A§Æ±æ¥i¥H¤@³Ò¥Ã¶h¸Ñ¨M³o°ÝÃD ...
  1. import requests
  2. import time
  3. from bs4 import BeautifulSoup

  4. ¥D´£³æ¸¹½X = ['160-69306532','608-10318674']

  5. with requests.session() as r:
  6.     res = r.get('https://accs.tradevan.com.tw/accsw-bin/APACCS/userLoginAction.do?userid=GUEST&password=GUEST')
  7.     for code in ¥D´£³æ¸¹½X:
  8.         print('¥D´£³æ¸¹½X :',code,'\n')
  9.         payload = {'mawb_no':code,'¬d¸ß':'¬d¸ß'}
  10.         res = r.post("https://accs.tradevan.com.tw/accsw-bin/APACCS/cImMergeQueryAction.do", data=payload)
  11.         res.encoding = "big-5"
  12.         html = BeautifulSoup(res.text,"html.parser")
  13.         for tr in html.body.select('table')[4].select('tr')[1:]: #½Ð¸Ô¾\w3school¸Ì¦³ÃöHTMLªºTable¼ÐÅÒª¾ÃÑ¡A´N¯àª¾¹D³o¸Ì¦b°µÔ£
  14.             data = [] #«Ø¥ß°}¦C
  15.             for td in tr.select('td'):
  16.                 data.append(td.text.strip())
  17.                 if td == tr.select('td')[len(tr.select('td'))-1]: #³o¸Ì¦³¤U¤@­ÓPOST©Ò»Ýªº¸ê°T(payload)¡A³z¹LÆ[¹îºô­¶­ì©l½X±oª¾
  18.                     print('²Ä¤G¦¸POSTªº¸ê®Æ :',td,'\n')
  19.             print('ºK­n¸ê°T :',data,'\n') #²Ä¤@¦¸¬d¸ß±o¨ìªººK­n¸ê®Æ
½Æ»s¥N½X
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

¦^´_ 18# sujane0701

Python¦³ÃöExcelªº¾Þ§@¦³«Ü¦h¤è¦¡¡Axlrd¼Ò²Õ¬O¨ä¤¤¤@ºØ
¯u¤ß·PÁ¨C¤@¦ìÄ@·N¤À¨É©Ò¾Ç¡B«ü¾É·s¤âªº¤H!

TOP

        ÀR«ä¦Û¦b : ¦³´¼¼z¤~¯à¤À¿ëµ½´c¨¸¥¿¡F¦³Á¾µê¤~¯à«Ø¥ß¬üº¡¤H¥Í¡C
ªð¦^¦Cªí ¤W¤@¥DÃD