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

[µo°Ý] google excelºô§}³s°Ê

[µo°Ý] google excelºô§}³s°Ê

½Ð°ÝB2¿é¤J2330
C2¤½¦¡¬O=IMPORTXML("https://histock.tw/stock/2330","//*[@id='Price1_lbTPrice']/span")

¤½¦¡¤¤¬õ¦âªº2330­n¦p¦ó¥Îb2¨ú¥N©O¡H
ÁÂÁ¤j¤j

coafort¤j ¬O³o¼Ë¶Ü  
B2=2330
=SUBSTITUTE("https://histock.tw/stock/2330","2330",B2)&"//*[@id='Pric ...
lucky12345 µoªí©ó 2022-4-18 05:49

ÁÂÁ¤j¤j
¤w¸g¦³§ä¨ì¤èªk¤F
=importxml("https://histock.tw/stock/" & B2,"//*[@id='Price1_lbTPrice']")

TOP

¥»©«³Ì«á¥Ñ lucky12345 ©ó 2022-4-18 05:54 ½s¿è

coafort¤j ¬O³o¼Ë¶Ü  
B2=2330
=SUBSTITUTE("https://histock.tw/stock/2330","2330",B2)&"//*[@id='Price1_lbTPrice']/span"
¥Ø«e¤p¾Ç¥Í´Á«Ý¥L¤é¶i°ê¤¤

TOP

        ÀR«ä¦Û¦b : ¤H­n¦Û·R¡A¤~¯à·R´¶¤Ñ¤Uªº¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD