¥xÆW³Ì¤jµ{¦¡³]­pªÀ¸sºô¯¸
½u¤W¤H¼Æ
1835
 
·|­ûÁ`¼Æ¡G245253
°Q½×¥DÃD¡G189111
Åwªï±z§K¶O¥[¤J·|­û
°Q½×°Ï¦Cªí >> VB.NET >> VB.NETŪ¨úEXCEL®É,¼ÐÃDÄæ¦ì´«¦æ¤§³B²z
[]  
[§Ú­n¦^ÂÐ]
1
¦^À³¥DÃD ¥[¤J§ÚªºÃöª`¸ÜÃD ÀËÁ|¦¹½g°Q½× ±N´£°ÝªÌ¥[¤J­Ó¤H¶Â¦W³æ
VB.NETŪ¨úEXCEL®É,¼ÐÃDÄæ¦ì´«¦æ¤§³B²z
»ù­È : 50 QP  ÂI¾\¼Æ:378 ¦^À³¼Æ:11

¼Ó¥D

¤pʹ¤l
ªù¥~º~
0 107
1211 162
µo°e¯¸¤º«H

VB.NETŪ¨úEXCEL®É,¦pªG¼ÐÃDÄæ¦ì¦³´«¦æ®ÉÀ³¦p¦ó³B²z
°²¦p¬Y¼ÐÃDÄæ¦ì[Ápµ¸¤H©m¦W]¦³³]©w´«¦æ,Ápµ¸¤H¤Î©m¦W¤ÀÄÝ¨â¦æ,¤U­±µ{¦¡À³«ç»ò§ï?
ÁÂÁÂ

·j´M¬ÛÃöTagsªº¤å³¹¡G [ EXCEL ] , [ ´«¦æ ] ,
¥»½g¤å³¹µoªí©ó2019-03-16 22:59
§O§Ñ®½VP·PÁÂÀ°§U§Aªº¤H ·s¤â·|­ûÁ@¤@Á@
1¼Ó
¦^À³

P³¯
ÀËÁ|¦¹¦^À³
Ū¶i¨Ó«á ¦AReplace §Y¥i

header1= replace(header,vbcrlf,"")
header1= replace(header,vblf,"")
header1= replace(header,vbcr,"")
¥»½g¤å³¹¦^ÂЩó2019-03-17 06:28
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
2¼Ó
§@ªÌ¦^À³

¤pʹ¤l
ÀËÁ|¦¹¦^À³
¤£¦n·N«ä,§Ú¥i¯à¨Sªí¹F²M·¡.
§Úªº°ÝÃD¬O¸ê®Æ®Ú¥»Åª¤£¶i¨Ó.¼ÐÃDÄæ¦ì[Ápµ¸¤H©m¦W]¦bEXCEL¤¤¬O¤À¦¨¨â¦æ,SELECE¤¤¥Î[Ápµ¸¤H©m¦W]©Î[Ápµ¸¤H]³£Åª¤£¨ì¸ê®Æ,
°£«D§â¼ÐÃD§ï¬°¤@¦æ
¥»½g¤å³¹¦^ÂЩó2019-03-17 10:34
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
3¼Ó
¦^À³

P³¯
ÀËÁ|¦¹¦^À³
±zµ{¦¡¤Î¸ê®Æ¥i¥H¥á¤W¨Ó¬Ý¤@¤U¶Ü?

µM«á§Ú¦b²q¤£¬O¨S¦³Åª¶i¨Ó¡A¬O§A¨S¦³¬Ý¨ì¦Ó¤w
¥»½g¤å³¹¦^ÂЩó2019-03-17 15:52
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
4¼Ó
§@ªÌ¦^À³

¤pʹ¤l
ÀËÁ|¦¹¦^À³
µ{¦¡¦³ÂI¶Ã,¤j·§¦p¤U,¦ýÀɮ׫ç»ò¤W¶Ç?

¥»½g¤å³¹¦^ÂЩó2019-03-17 22:59
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
5¼Ó
§@ªÌ¦^À³

¤pʹ¤l
ÀËÁ|¦¹¦^À³
¦bMsgBox(myDS.Tables("AAA_R").Rows.Count) ·|¥X²{NullReferenceException°T®§
¥»½g¤å³¹¦^ÂЩó2019-03-17 23:06
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
6¼Ó
¦^À³

P³¯
ÀËÁ|¦¹¦^À³
Catch ex As Exception
¡i³oùجOªÅªº¡j<<----¤£¥¿±`
msgbox (ex.message) <----½Ð¥ý§ï¦¨³o¼Ë ¸Õ¤@¤U

End TRY

°£«D§â¼ÐÃD§ï¬°¤@¦æ <--- ³o¼Ë´NŪ±o¨ì ???
------------------------------------
¦pªG¨S¦³¿ù»~°T®§ªº¸Ü
Àɮפ£¥Î¤F §Ú¦Û¤w²£¥Í§Y¥i
¥»½g¤å³¹¦^ÂЩó2019-03-17 23:26
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
7¼Ó
§@ªÌ¦^À³

¤pʹ¤l
ÀËÁ|¦¹¦^À³
½T©w§â¼ÐÃD§ï¬°¤@¦æ³o¼Ë´NŪ±o¨ì.
ÁÂÁÂ
¥»½g¤å³¹¦^ÂЩó2019-03-17 23:35
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
8¼Ó
³Ì¦³»ù­È¸Ñµª

P³¯
ÀËÁ|¦¹¦^À³
±zªºµ{¦¡ ¸g§Ú´ú¸Õµ²ªG ¬O¥i¥H°õ¦æªº ¤]¥i¥HŪ¸ê®Æ¶i¨Ó
1.µ{¦³¤@­Ó¦a¤è¤p¿ù (Like «e¨S¦³ªÅ¤@®æ)
str1 = "SELECT * FROM [sheet1$A3:K65535] where Ápµ¸¤H©m¦W¤Î¹q¸Ülike '%(07)%'"

2.·íÄæ¦W¬° ABC ©Î DEF ®É¡AŪ¤JTABLE «á´N¬O ABC DEF¡A¦ý ¡iABC´«¦æDEF¡j¡AÄæ¦W·|¦Û°Ê¥[¡i__¡jÅܦ¨ ABC_DEF
¥»½g¤å³¹¦^ÂЩó2019-03-18 07:33
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
9¼Ó
¦^À³

P³¯
ÀËÁ|¦¹¦^À³
¦³µo¯¸¤º«Hµ¹±z¤F¡A½Ð¦¬
¥»½g¤å³¹¦^ÂЩó2019-03-18 07:39
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
10¼Ó
§@ªÌ¦^À³

¤pʹ¤l
ÀËÁ|¦¹¦^À³
·PÁÂP³¯¤j¤j,¦bÄæ¦W¤¤¥[¡i__¡j´N¥i¥H¤F,ÁÂÁÂ
¥»½g¤å³¹¦^ÂЩó2019-03-18 23:12
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
11¼Ó
¦^À³

P³¯
ÀËÁ|¦¹¦^À³
¤w§@¥X¨Ó´N¦n¤F
¥»½g¤å³¹¦^ÂЩó2019-03-19 20:22
== ñ¦WÀÉ ==
--¥¼µn¤Jªº·|­ûµLªk¬d¬Ý¹ï¤èñ¦WÀÉ--
   
1

¦^ÂÐ
¦p­n¦^À³,½Ð¥ýµn¤J.