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

[µo°Ý] ÃÒ¥æ©Ò¸ê®Æ¦Û°Ê¤U¸ü

[µo°Ý] ÃÒ¥æ©Ò¸ê®Æ¦Û°Ê¤U¸ü

¥»©«³Ì«á¥Ñ lalalada ©ó 2012-7-27 15:58 ½s¿è

ÃÒ¥æ©Òºô¯¸³ºµM§ïª©¤F£½£¿ ¤~­è¼g¦nªº»¡
§¹¥þ¨S¦³·s¤âªº¦n¹B....
    ActiveSheet.name = sheetname
    webURL = "URL; http://bsr.twse.com.tw/bshtm/bsContent.aspx? StartNumber=2498&FocusIndex=All_21"
    'webURL = "URL; http://bsr.twse.com.tw/bshtm/bshtm_report_Messages.aspx? StartNumber=2498&FocusIndex=All_100"   ¦ì§}·|´«!
    With ActiveSheet.QueryTables.Add(Connection:=webURL, Destination:=Range("A1"))
        .PreserveFormatting = True
        .RefreshStyle = xlInsertDeleteCells
        .WebSelectionType = xlSpecifiedTables
        .WebFormatting = xlWebFormattingNone
    End With
¤¤¶¡¦³¦æµù¸Ñ´N¬O²Ä¤@¦¸§ïª©ªº¨£ÃÒ....''(§ïºô§})
¦Ó³o¦¸§ïª©«á ¥»¨Ó¨Ï¥Î http://bsr.twse.com.tw/bshtm/bsC ... ;FocusIndex=All_100
´N¥i¥H¾A¥Î¨C¤äªÑ²¼ ¥u­n§ï¥N½X´N¦n
¦ý¬O²{¦b­n«ü©w­¶¼Æ
¤ñ¦p3008ªº¸ê®Æ¦@20­¶  http://bsr.twse.com.tw/bshtm/bsC ... p;FocusIndex=All_20
«hALL«á­±¿é¤J1~20³£§ì±o¨ì ¶W¹L20«hµLªkŪ¨ú
¤£ª¾¹D¯à¤£¯à§ä¥Xºô¯¸¨M©w­¶¼Æªº¤èªk©O?
¤S §Ú¦bºô¯¸­ì©l½X view-source:http://bsr.twse.com.tw/bshtm/bsMenu.aspx  ¤¤µo²{
//    window.open("bshtm/"+ HiddenField_spDate +"/"+ document.getElementById("hidTASKNO").value+"/"+ document.getElementById("hidTASKNO").value+".csv");
window.open("bsContent.aspx?StartNumber=" + document.getElementById("hidTASKNO").value + "&download=csv");
ªí¥Ü¦³csvÀɧ@¬°ºô­¶¸ê®Æ·½?¦³¨S¦³¿ìªk§ì¨ì©O?
·Pı·|¬O¤ñ¸û¤@³Ò¥Ã¶hªº°µªk ¥B¤U¸ücsv·|¤ñ¬d¸ß§Ö«Ü¦h
·P¿E¤£ºÉ!

°ÝÃD¤w¸Ñ¨M! ¶¶«K­×¤F¤@¤U­ì¥»¶Kªºµ{¦¡½X §â¤Ó¶ÃµLÃöªº³¡¤À§R±¼¤è«K¤j®a¬Ý@@

Python ©Î VBA  ­þ­Ó¦n¥Î?

TOP

¤µ¤Ñ²×©ó¶}©l¤U¸ü¸ê®Æ¤F
½Ð°Ý½Ö¦³¤§«eªº¸ê®Æ ¥i¥Hµ¹§Ú
·P¿E¤£ºÉ
[email protected]

TOP

»Ý­n¦¹Àɨӽm²ß¤@¤U
Æg°Õ

TOP

phthon¦n¹³«Ü¦n,¦³½Ö¥i¥H¤À¨Épython§ì¸ê®Æªº¤èªk?
stock

TOP

¥»©«³Ì«á¥Ñ white5168 ©ó 2012-7-28 00:00 ½s¿è

ªþ¤W¤µ¤Ñ¥ÎPYTHON¶]ªº¹Ï

1.gif (996.47 KB)

¶}©l

1.gif

2.gif (999.45 KB)

¤¤¶¡

2.gif

TOP

¥»©«³Ì«á¥Ñ conchih ©ó 2012-7-27 16:20 ½s¿è

¦^´_ 23# lalalada
§Q¥ÎGET
¥ýŪ¨ú­ì©l½X
¦]¬°§Úªºµ{¦¡²{¦b¥¿¦b¶]©Ò¥H´N¤£¶K¤F
³o³¡¤À¸ò§ìCSV¬O¤@¼Ëªº §ïºô§}§Y¥i
  


¥i§_½Ð¤j¤jÀ°¦£
µ¥µ{¦¡¶]§¹&¦³ªÅ®É
¶K¤@¤UGET¨º¬qªººô§}»Pµ{¦¡½X
¦]¬°§ÚµLªk§ì¨ìÁ`­¶¼Æ
«D±`·PÁÂ

TOP

ªþ¤W¤@­Ó¥Îpython§ìªºÀÉ®×,µy±ß5:30«á¦Aªþ¤W¤µ¤Ñ¥Îpython§ì©ú²ÓªººI¹Ï

1101_20120726.rar (3.58 KB)

劵°Ó©ú²Ó

TOP

¦^´_ 3# lalalada

¶â §Ú¦¨¥\¤F
°ò¥»¤W´N¦p¤@¶}©l°²³]
§Q¥ÎGET
¥ýŪ¨ú­ì©l½X
¦]¬°§Úªºµ{¦¡²{¦b¥¿¦b¶]©Ò¥H´N¤£¶K¤F
³o³¡¤À¸ò§ìCSV¬O¤@¼Ëªº §ïºô§}§Y¥i
µM«á§ì¥X­¶½Xªº³¡¤À
³Ñ¤Uªº´N¸ò¥H«e¤@¼Ë@@
¤£¹L¤S§óºC¤F....¦Ó¥B¥X²{¤¤Â_²{¶H
´Á«Ý¤K¤ëªºCSV§a ÁöµM¥i¯à­n¥I¶O= =
¦A¦¸·PÁ¤j®aªº¼ö±¡°Q½×»P«ü±Ð:)!!

TOP

manny

TOP

        ÀR«ä¦Û¦b : ¬O«D·í±Ð¨|¡AÆg¬ü§@ĵ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD