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

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

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

¤p§Ì¦]¾°ÈÃö«Y,¨C¤é¶·¬d¸ß¤j¶qºô­¶¸ê®Æ(60~100µ§,¥B¤£Â_­«ÂЬd¸ß),¨ÃKEY IN¦¨³øªí,¹ê¦b¤Ó¹LÁcº¾,¥H«e¥i¥H§Q¥ÎWEB¬d¸ß§ì¨ú©Ò¶·¸ê®Æ,¦ý¬O²{¦bºô­¶¤wµLªk¶¶§Q§ì¨ú,Å¥»¡¥²¶·§Q¥Î¨ìVBA¤~¯à§¹¦¨,¦]¤p§Ì§¹¥þ¤£À´VBA,¥u¦n«pÃCÀµ½Ð¤j¤jÀ°¦£... ¥D´£³æ¬d¸ß.rar (80.12 KB)

¦^´_ 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

ÁÂÁ¤j¤j«ü¾É,¤p§Ì»°§Ö¥h¬ã¨s

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

¥»©«³Ì«á¥Ñ sujane0701 ©ó 2017-2-7 19:02 ½s¿è

ÁÂÁ¤j¤j,¤p§Ì°ò¦¥þµL,¬Ý¤F¥|½gºô¸ôª¦ÂΪºµøÀW,²£¥Í¤F³\¦h¤£©ú¥Õªº¦a¤è,ÁöµM¤w¸gÁô¬ù©ú¥Õ¤j¤j«üÂI¾Ç²ß³o­Óªº­ì¦],¦ý¬O¦³³\¦h¦Wµü¤Î­ì²z¦³Å¥¨S¦³À´,«á­±¤w¸g¤£´±¦A¬Ý¤U¥h¤F,¥¿¦b¨ì³B¥´Å¥¦³¨S¦³¬ÛÃöªº°ò¦®ÑÄy,¤j¤j¬O§_¥i¥H¤¶²Ð¤@¨Ç¤Jªù®ÑÄy?
¥t¥~½Ð±Ð¤@ÂI³Ì¤£©ú¥Õªº¦a¤è,½Ð°Ý±z²{¦b´£¨Ñªº½d¨Ò,¬Oexcel vba¶Ü?¥i¥Hª½±µ¦bexcelÃþ¦ü¥¨¶°¤@¼Ë»s§@±±¨î¶s¤§Ãþªº¬O¶Ü? §Úª¾¹D°ÝÃD¤Q¤À²LÁ¡¥i¯º,¥i¬O¤p§Ì¹ê¦b¤£À´,½Ð¤j¤j¤£§[¼·ªÅ«ü¾É~

TOP

À´¤FÀ´¤F!¬Ý§¹²Ä¤­,¤»½g¤¶²Ð,ª¾¹DPython3¥i¥H±N³X°Ýµ²ªGÂনexcel,§Î¦¨¤@­ÓÃþ¦ü¸ê®Æ®w¨Ó·½ªºÀÉ®×,¤è«K»s§@³øªí,«e­±°Ýªº²Â³J°ÝÃD,½Ð¤j¤j¤£­n²z§Ú.....

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

¦^´_ 1# sujane0701

«Øijªd§âVBA¤j¤jµ¹ªº¼v¤ù¡A¤j¼Æ¾Ú¾Ç°ó¬ÛÃöªº«e¤Q­Ó¼v¤ù¥þ¬Ý§¹
°ò¥»ªº´N·|¤F¡A¤p§Ìª¦¦äªºª¾ÃÑ¥þ¬O¾a³oºô¯¸ªº¼v¤ù«ü¾Éªº
¨ä¥¦ªº½Ð¥ÎGOOGLEªd¦Û¤v­nªº¥\¯à¡A´N·|¦³½d¨Ò¤F¡A¤£¹L¤j¦h¬°Â²Åé¦r
¥ýµ¹ªd³o²©ö»¡©úªººô§}¬Ý¬Ý
http://www.runoob.com/python/python-100-examples.html

PS:¦]¬°ªd¬O­n§ì¶iXLS¡A¦³ª½±µ¥i¥H¦s¦¨XLSªº®M¥ó  OR  ¥t¦s¦¨ TXT CSV ¬Ò¥i

python³o®M¹ï©óºô§ì¨Ó»¡¡A²³æ¬O²³æ¡A¦ýÁÙ¬O­nªá¶O¤@¨Ç®É¶¡¥h¤F¸Ñªº¡A©Ò¥H¦h¸Õ¸Õ§a
¥ý¸Õ¥X¯à´£¨ú¤@µ§¦s¦bxls¤§«á¡A¦b¥Î°j°é¨Ó³v¤@¥Î¥D´£³æ¸¹½X´£¨ú¸ê®Æ´N¤è«K³\¦h¤F
¦pªG¯uªº¸ê®Æ¶q¤Ó¤jªº¸Ü¡A¨ì®É¦b¥h¬ã¨s sqlite3®M¥ó¨Ó°t¦Xxls§Y¥i¡A¥u¤£¹L¤S­n¦h¾Ç²ß sql »yªk

TOP

·PÁÂVBALearner¤Î koshi0413 ¨â¦ì­@¤ß,¬Ý¹LµøÀW«á¬ðµMµo²{²´¬É¤j¶},«Ü§Æ±æ¾Ç·|§ì¨úºô¸ô¸ê®Æªº§Þ³N,¬Q¤Ñ¯S¦a¥h¶R¤F¤@¥»ºô­¶³]­p¤Jªù,´Á±æ¦b¤u§@¤§¾l¥´¤@ÂI°ò¦,¦A¦¸ÁÂÁÂ2¦ì¤j¤j«ü©ú¾Ç²ß¤è¦V,«D±`·PÁÂ~

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD