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

[µo°Ý] ¤WÂd­ÓªÑ¦~¦¨¥æ¸ê°Tiqy»s§@

[µo°Ý] ¤WÂd­ÓªÑ¦~¦¨¥æ¸ê°Tiqy»s§@

½Ð°Ý¦U¦ì°ª¤â.¦p¦ó§âhttp://www.gretai.org.tw/ch/stock/statistics/monthly/st42.php°µ¦¨°ÊºA¸ê®Æ¬d¸ß(­ÓªÑ¦~¦¨¥æ¸ê°T)?
¦pªG¯à¦³»s§@µ{§Ç§ó¦n.¥ý¦b¦¹ÁÂÁ¤F.
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

¦^´_ 1# bhsm
XL97¡G ¦p¦ó«Ø¥ß Web ¬d¸ß (.iqy) ÀÉ®×
  1. WEB
  2. 1
  3. http://www.gretai.org.tw/ch/stock/statistics/monthly/st42.php
  4. input_stock_code=["¥N½X","½Ð¿é¤J¤WÂdªÑ²¼¥N¸¹¡G"]
  5. Selection=3
  6. Formatting=None
  7. PreFormattedTextToColumns=True
  8. ConsecutiveDelimitersAsOne=True
  9. SingleBlockTextImport=False
  10. DisableDateRecognition=False
  11. DisableRedirections=False
½Æ»s¥N½X

TOP

¦^´_ 2# stillfish00
·PÁÂstillfish00¤j.¯à§_½Ð±Ð»s§@µ{§Ç?¦]¬°³o­Óºô­¶¤£¬O¥Î¤@¯ëªº"¶×¥X¦Ü Microsoft Excel(X)"¥i¸Ñ¨Mªº.
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

¦^´_ 3# bhsm
Excel 2010¡G
1.   ¸ê®Æ>¨ú±o¥~³¡¸ê®Æ>±qWeb¡A
      µøµ¡¶}±Ò«á¡A¦a§}¶ñ http://www.gretai.org.tw/ch/stock/statistics/monthly/st42.php
      ¥ý¿ï¨ú§A­nªºªí®æ¡AµM«áÀx¦s¬d¸ß(iqy)¡A¨ú®ø¶×¤J¡C
2.   ¥H¤å¦r½s¿è¾¹¥´¶}­è­è¦sªºiqy¡A²Ä¥|¦æ­ì¬°ªÅ¥Õ¡A
      ¸Ó¦æ©ñPOST¦r¦ê¡A­×§ï¬° input_stock_code=["¥N½X","½Ð¿é¤J¤WÂdªÑ²¼¥N¸¹¡G"]
      ¦sÀÉ¡C
3.   ¸ê®Æ>¨ú±o¥~³¡¸ê®Æ>²{¦³³s½u¡A¿ï¸ÓiqyÀÉ¡A«á­±´N·ÓµÛ°µ´N¦n¤F¡C

¦Ü©óPOST¦r¦ê¬°¦ó¡A´N­n¦Û¤v§ä¤F¡A¤£¦PÂsÄý¾¹¦³¦U¦Ûªº²Ä¤T¤è³nÅé¥i¥H¤è«K¬d§ä¡C
¦ý¤£¥Nªí©Ò¦³ºô­¶³£¯à¥Îiqy´N¯à§ì¨ì§A­nªº¸ê®Æ¡A¦³¨Çºô­¶POST¦r¦ê¬OÅܰʪº(Serverµ¹§Aªº)¡C

TOP

¦^´_ 4# stillfish00
·PÁÂstillfish00ªº«ü±Ð,¤p§Ì«ö·Ó±zªº¤èªk¦b"  ¥ý¿ï¨ú§A­nªºªí®æ¡AµM«áÀx¦s¬d¸ß(iqy)"§ÚµLªk¿ï¾Ü§Ú­nªºªí®æ.¦p©Òªþªº¹ÏÀÉ.¥u¯à¿ï¾Ü¥þ­¶.¤£ª¾¾Þ§@µ{§Ç¤W­þ¸Ì¦³»~?·Ð½Ð«ü¾É.ÁÂÁÂ

web.png (224.02 KB)

web.png

¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

¦^´_ 4# stillfish00
·PÁÂstillfish00¤j.°ÝÃD¤w¸Ñ¨M.¥i¥H¦p±z©Ò±Ðªº.¥Ñ°J·PÁ±z
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

¦^´_ 1# bhsm

¦³¨ÇªÑ²¼¿é¤J¦³¸ê®Æ ¦³¨Ç¨S¦³¸ê®Æ ?
¨S¦³±j¨î¨C­ÓªÑ²¼³£­n¤½¶}¸ê®Æ¶Ü?

¤£ª¾§A¤F¤£¤F¸Ñ³o­Ó°ÝÃD¡A¥i§_¦^ÂФ@¤U
{...} ªí¥Ü»Ý­n¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡

TOP

¦^´_ 7# ML089
¥Ø«e§Ú­n¬dªºªÑ²¼³£¨S°ÝÃD.¤£ª¾§A¦³°ÝÃDªº¬O­þ¤äªÑ²¼?·|¤£·|¬O¿é¤J¤F¤W¥«¤½¥qªº¥N½X.¦]¬°³o¬O¤WÂd¥Îªºiqy
¦~ÄÖ¤£¤p,¦ý§Ú«Ü·Q¾Ç

TOP

        ÀR«ä¦Û¦b : ¨C¤ÑµL©Ò¨Æ¨Æ¡A¬O¤H¥Íªº®ø¶OªÌ¡A¿n·¥¡B¦³¥Î¤~¬O¤H¥Íªº³Ð³yªÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD