c_c_lai

¦^´_ 39# lpk187
¦^´_ 40# zyzzyva
ÁÂÁ§A¡I
½Ð°Ý 3714 ¥Nªíµ§¼Æ¶Ü¡H
¦pªG­nÅã¥Ü Get «áªººô­¶¤º®e¨º¸Ó¦p¦óªí¹F¡H

¤U¸ü (72.56 KB)

2016-9-7 18:35

c_c_lai

¦^´_ 43# lpk187
ÁÂÁ§A¡I
³o¬O¤£¬O«ü Pandas ®M¥ó©|¥¼¦w¸Ë¡H
½Ð°Ý¤U¸üPandas®M¥ó«á¡A ­n¦p¦ó¥[¤JPandas ®M¥ó¡H
·Pı¤W¤ñ Excel VBA ÁÙ½ÆÂøËç¡C

¤U¸ü (135.32 KB)

2016-9-8 06:59

c_c_lai

¦^´_ 42# zyzzyva
ÁÂÁ§A¡I
°õ¦æ§¹«á¥X¨Óªº¬Oºô­¶­ì©l½X¡A
¦p°ê§Ú·Q­nªº¬O¦p§A¤W¹Ïªºµ²ªG­È¡A
¨º¤S¸Ó¦p¦ó³B²z¡H
§Ú¬O¦b·Q¤F¸Ñ Python ¥¦¬O¦p¦ó¨Ó§¹¦¨¡H

¤U¸ü (120 KB)

2016-9-8 07:07

c_c_lai

¦^´_  c_c_lai

html¤ñ¸û¦h°ÝÃD¡A ·í§A¦³html5lib / LXML¸ÑªR¾¹ªº°ÝÃD
§A¥i¥H¤U¸ü¥¦
pip install html ...
lpk187 µoªí©ó 2016-9-8 00:05

¤£¦n·N«ä html5lib / LXML ­n¦p¦ó¤~¯à¤U¸ü¨ì¡H
¤U¸ü«á§Ú¬O¦b¦w¸Ëªº Python 3.5 ªºÀô¹Ò¤U °õ¦æ pip install ¡H
¦ý¬O¥Ø«e§Ú¤£ÃѦb¸ÓDOS Àô¹Ò¤U°õ¦æµ{¦¡¡A¦Ó¬O³z¹L Anaconda ªº
Jupyter Àô¹Ò¤U°õ¦æµ{¦¡¤U¡A¨º¤SÀ³¸Ó­n¦p¦ó¹B§@¡H
¤£¦n·N«ä¤@¤f®ð´£¥X³o»ò¦hªººÃ°Ý¡A¦]µL¤H±Ð¾É¦Û¾Çªº¡A
©Ò¥H©|½Ð¦h¦h¥]²[¡C¦A¦¸¦V§A»¡ÁnÁÂÁÂÅo¡I

c_c_lai

¦^´_ 48# lpk187
«D±`·PÁ¡A§Ú¨Ó¾ÇµÛ¸Õ¸Õ¦w¸Ë¬Ý¬Ý¡A
§Ú¬Ý¤F Anaconda ªº»¡©ú³£¨S´£¤Î¡A©Ò¥H¦Ü¤µÁÙ¬O¥®¨àªì¯Å¥Í¡A
ºF·\ºF·\¡I
¨º»ò Python 3.5 ªºÀô¹Ò¤U¬O§_¨Ì»Ý¦p¦P  Anaconda Script ¤@¼Ë
»Ý­n°õ¦æ Pip ªº®M¥ó¨Ó¦w¸Ë¤É¯Å¡H

c_c_lai

¦^´_ 48# lpk187
­×¥¿®M¥ó«á¡A°õ¦æ¤§µe­±¦p¤U¡A¬Ý°_¨Ó¬O OK¡A
¦ý«o¨S¬Ý¨£ Test.xlsx ÀɮסH¥¦·|²£¥Í¦b­þ¸Ì¡H
³o¼Ëªºµe­±Åã¥Ü¬OÄÝ¥¿½T¶Ü¡H
ÁÂÁ§Aªº«ü¾É¡I

¤U¸ü (85.47 KB)

2016-9-8 10:04

c_c_lai

¦^´_ 51# zyzzyva
ÁÂÁ§A¡I
§Ú·Q¨D¥X¦p¤U¤§¤º®e (µ²ªG) (¦p¹Ï¥Ü)¡G
¤£ª¾¥i¦æ§_¡A¦p¦¹§Ú¤]±o¥H¾Ç¨ì¦p¦ó§ì¨úºô­¶¸ê®Æ¡C
¤@¿s Python ¬O¦p¦ó»´©ö¯à±oª¾µ²ªGªº¡C

¤U¸ü (45.68 KB)

2016-9-8 10:30

c_c_lai

¦^´_ 51# zyzzyva
§Ú·Q­nªº¥X¨Óµ²ªG¬O¡G(¦p ¤U)

1. Sub Ex()
   
2.     Dim strURL$ '«Å§istrURL¬°ÅܼÆ
   
3.     strURL = "http://www.taifex.com.tw/chinese/3/7_12_3.asp"    '©w¸qstrURLÅܼƤº®e
   
4.     [a1].CurrentRegion.ClearContents   '  ²M°£¤å¦r¨S²M°£®æ¦¡(¬ü¤Æ¦nªºªí®æ)
   
5.    
   
6.     With ActiveSheet.QueryTables.Add(Connection:= _
   
7.                   "URL;" & strURL, Destination:=Range( _
   
8.                   "$A$1"))
   
9.         .Name = "´Á³f«´¬ù"
   
10.         .FieldNames = True
    
11.         .RowNumbers = False
    
12.         .FillAdjacentFormulas = False
    
13.         .PreserveFormatting = False
    
14.         .RefreshOnFileOpen = False
    
15.         .BackgroundQuery = False
    
16.         .RefreshStyle = xlOverwriteCells
    
17.         .AdjustColumnWidth = False
    
18.         .WebSelectionType = xlSpecifiedTables
    
19.         .WebFormatting = xlWebFormattingNone
    
20.         .WebTables = "3"         '   ²Ä 3 ­Ó Table
    
21.         .WebPreFormattedTextToColumns = True
    
22.         .WebConsecutiveDelimitersAsOne = True
    
23.         .WebSingleBlockTextImport = False
    
24.         .WebDisableDateRecognition = True
    
25.         .WebDisableRedirections = False
    
26.         .Refresh BackgroundQuery:=False
    
27.         .Delete
    
28.     End With
    
29. End Sub

½Æ»s¥N½X

¤U¸ü (37.55 KB)

2016-9-8 10:50

c_c_lai

¦^´_ 52# zyzzyva
¦^´_ 43# lpk187
¤º®e¬O¡H

¤U¸ü (60.52 KB)

2016-9-8 10:56

c_c_lai

¦^´_ 57# lpk187
¦^´_ 58# zyzzyva
ipython ªº¸Ü´N¦p zyzzyva ¤j¤j©Ò»¡ªº¡A
·|¦s¦b¦b C:\Users\ µn¤J¤¤¨Ï¥ÎªÌ©³¤U¡C
¦b¦¹¦V§A­Ì¾Ç¨ì¤F¤£¤Ö Python ªº¦³Ãöª¾ÃÑ¡A
³o¥ç¬O«e°}¤l§Ú¬°¦ó±N Python °±Â\ªº½t¬G¡A
ÁÂÁ§A­ÌËç¡I