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

[µo°Ý] ¦p¦ó¨Ï¥ÎexcelŪ¨úÃÒ¥æ©Ò°ò¥»¥«ªpªººô­¶©O

[µo°Ý] ¦p¦ó¨Ï¥ÎexcelŪ¨úÃÒ¥æ©Ò°ò¥»¥«ªpªººô­¶©O

½Ð±Ð¤j®a
¦p¦ó¨Ï¥ÎexcelŪ¨úÃÒ¥æ©Ò°ò¥»¥«ªpªººô­¶©O
(http://mis.twse.com.tw/)
§Ú¦³¥Î¹L ¶×¤J¥~³¡ºô­¶¸ê®Æ ¨S¦³¥Î
¥Îyahooªº¥i¥H¥¿±`Ū¨ú

½Ð±Ð¤j®a ¸Ó«ç»òŪ¨ú©O
ÁÂÁÂ

¦^´_ 1# JERRYHUANG123


    ½Ð°ÝJERRYHUANG123 ¤j¦p¦ó¨Ï¥ÎexcelŪ¨úÃÒ¥æ©Ò°ò¥»¥«ªpªººô­¶©O
   ¥Î£{¦n¤[³£¥Î¤£¥X¨Ó~~

TOP

JERRYHUANG123  ¤j
excel¶×¤J°ò¥»¥«ªp³ø¾Éºô­¶¸ê®Æ¤èªk§xÂZ¦n¤@¬q®É¶¡
§ä¨ì¤@¨Ç¸ê®Æ¦n¹³¬O­n¥Î¨ä¥¦µ{¦¡»y¨¥¦pC++
¸ê®Æ¦p¤U:
http://delphi.ktop.com.tw/board.php?cid=31&fid=79&tid=90736

½Ð°Ý:
§A¦p¦ó³z¹Lexcel§ì¨ì¸ê®Æ
§ÚµL½×¦p¦ó¸Õ³£¬OªÅ¥Õ¡K¡K¡K¡K¡K¡K.

TOP

A2=--INDEX(A,,3)

½Ð°Ý¤@¤U

¤W¦C¤½¦¡¤¤ "--" ¬O¬Æ»ò·N«ä
mustang µoªí©ó 2011-2-24 00:03



    ¦]¬°Â^¨úªº¼Æ¦rÄÝ©Ê¥i¯à¬O"¦r¦ê"¡A¥[¤W"--"«áÄÝ©Ê·|¦Û°ÊÅܦ¨"¼Æ­È"¡A¼Æ¦r¸ê®Æ¤~¯à³Q¥|«h¹Bºâ!  ³Ì¶}©lªº·s¤â±Ð¾Ç¤å³¹¦³»¡³á....
ÁÂÁÂ! :)

TOP

A2=--INDEX(A,,3)

½Ð°Ý¤@¤U

¤W¦C¤½¦¡¤¤ "--" ¬O¬Æ»ò·N«ä

TOP

ÁÂÁ ¥i¥H¥Î¤F
¥t¥~½Ð±Ð  excel±µ±d©Mªºdde
§Ú¶Ç¿é¤F¤W¦ÊÀɪºªÑ²¼ ¨ìexcel
µ²ªG¤§«áµo²{ excel¦³®É·|°±¦í ´N¬O¤£¦A§ó·s
½Ð°Ýexcel±µdde¦³¤W­­¶Ü?

§Ú¬O²{¦b·Q­n´«¦¨ ¥Ñºô­¶¤U¸ü¨Ó
³o­Ó¤]·|¦³¤W­­¶Ü  ÁÂÁÂ

TOP

¦^´_ 13# JERRYHUANG123


    ¦r¤¸¼Æ¶W¹LEXCELÀx¦s®æ³Ì¤j®e³\¦r¤¸¼Æ
split.rar (7.52 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

§Ú­è¸Õ §â«e­±ªº 1102,®³±¼
´N¥i¥H¥¿±`Åã¥Ü¤F
¥i¬O§Ú±qºô¸ô§ì¸ê®Æ¤U¨Ó  «e­±ªº¥N½X¤@©w·|¦³ªº
ÁÙ¬O¨º¸Ì¦³¥X°ÝÃD¤F©O  >"<

TOP

§Ú¥»¨Ó¤]¬O¥Î³o­Ó¤è¦¡
¥i¬O¥¦ªº­È«o¤@ª½¥X¿ù §Ú©w¸q¨ºÃä³£³]¤@¼Ë¤F
¥u¬OÀx¦s®æ§â¥¦´«¦¨¬O±q¥~³¡¶×¤J¸ê®Æ¶i¨Ó
µ²ªG´N¤£¦æ
´N¹³ªþ¥ó³o¼Ë
½Ð°ÝÁÙ¦³¤°»ò¦a¤è»Ý­n§ïªº¶Ü
ÁÂÁÂ




split.rar (7.93 KB)

TOP

¦^´_ 11# JERRYHUANG123
¥ÎGONGª©¥Dªº¤èªk
°²³]A1¬°¸Ó¬d¸ß±o¨ìªº¸ê®Æ
©w¸q¦WºÙx
=EVALUATE("{"&¤u§@ªí1!$A$1&"}")
A2¤½¦¡
=INDEX(x,,COLUMN())
¦V¥k½Æ»s
split.rar (6.52 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ±o²z­nÄǤH¡A²zª½­n®ð©M¡C
ªð¦^¦Cªí ¤W¤@¥DÃD