ÇóÖú¹ØÓÚVB¶¯Ì¬¿ØÖÆEXCEL±í¸ñ±ß¿ò - VB / »ù´¡Àà
ÎÒÓÃÒÔÏ´úÂëÍùEXCELÀïÌí¼ÓÊý¾Ý£¬×îºóÒª°Ñ±í¸ñ±ß¿òÉèÖóöÀ´£¬Ê¹ÓÃÁËÂ¼ÖÆºêµÄ°ì·¨
Ò»¸öÊÇÔÚ¼ÓÁËÒ»ÐÐÊý¾ÝÒÔºóÌí¼Ó±ß¿ò£¬Ò»ÖÖÊÇÈ«²¿Êý¾Ý¶¼Ìí¼ÓÍê±Ïºó£¬ÓÃÒ»¸ö°´¼üΪÕû¸ö±í¸ñÌí¼Ó±ß¿ò£¨ÏÂÁдúÂëΪºóÕߣ©£¬µ«ÊǶ¼³öÏÖÁ˶ÔÏó±äÁ¿»òwith¿é±äÁ¿Î´ÉèÖõÄÌáʾ£¬ºóÀ´ÎÒÊÔÁËһϣ¬Æô¶¯³ÌÐòºó²»Ìí¼ÓÊý¾Ý£¬Ö±½ÓÌí¼Ó±ß¿òÊdzɹ¦µÄ£¬µ«ÊÇÔٴεã»÷Ìí¼Ó±ß¿òÓÖÊÇÕâ¸öÌáʾ£¬»³ÒÉÊÇrangeµÄÎÊÌ⣬Çë¸ßÊÖÃǰïæָµãһϰ¡
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
Dim hang As Long '¼ÆËãÌí¼ÓÁ˼¸ÐÐÊý¾Ý
¡¯Ìí¼ÓÒ»ÐÐÊý¾Ý
Private Sub Command2_Click()
Dim content(10) As String
content(0) = Time
For i = 1 To 9 Step 2
content(i) = 12.5
Next
For i = 2 To 10 Step 2
content(i) = 22.11
Next
Set xlApp = CreateObject("Excel.Application")
xlApp.DisplayAlerts = False '²»ÏÔʾÊÇ·ñ±£´æ
Set xlBook = xlApp.Workbooks.Open("C:\exper.xls")
On Error GoTo 0
Set xlSheet = xlBook.Worksheets(1)
xlApp.Visible = False '²»ÏÔʾ³ö´´½¨µÄÎļþ
xlSheet.Activate
For i = 0 To 10
xlSheet.Cells(hang, i + 1) = content(i)
Next
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÎÒÏë¸ù¾ÝtreeviewÉÏÿ¸ö½ÚµãµÄȨÏÞ£¬Ã»ÓÐȨÏ޵Ľڵ㲻Äܱ»Ñ¡ÖУ¬¶øÇҳɻÒÉ«£¬ÔõôʵÏÖ£¬ÔÚÏߵȡ£¡£¡£
Õâ¸ö£¿¡£¡£¡£
Ã²ËÆÃ»·¨¡£
ÊÔÊÔÄܲ»ÄܸÄijЩnodeµÄÑÕÉ«£¬¼Ç¼ÏÂÉϴεÄnodeclickÀïµÄnode¡£
Ï´εã»÷µÄÈç¹ ......
vbÖÐ ÏÖÔÚÎÒÒª°ÑÊý¾Ý¿âÀï´æ´¢µÄÒ»¸ö¸½¼þµÄÄÚÈÝÌæ»»ÁË£¬Ôõô×ö£¬Ö»ÊÇÌæ»»ÎÒÖ¸¶¨µÄλÖ㬲»ÊÇÈ«²¿Ìæ»»
Ç뽫ÎÊÌâ˵Ã÷°×£¬´æ´¢×ֶθñʽ£¬Èç¹ûÊÇBinary¸ñʽµÄ±È½ÏÂé·³£¬Èç¹ûÊÇ×Ö´®£¬Ö±½ÓÌæ»»¡£×îºÃ²»Òª½øÐÐÖ¸¶¨Î»ÖÃÌæ»»¡ ......
xmlDoc1.loadXML(h)×ÜÊÇ·µ»Øfalse£¬ÎªÊ²Ã´£¿Ð»Ð»°ïæ»Ø´ðÒ»ÏÂ
hÊÇÊ²Ã´ÄØ¡£¡£¡£¡£¡£¡£¡£¡£¡£
hÊÇxml¸ñʽµÄ×Ö·û´®
ÄãÊÇÏë´ò¿ª¡£XML¸ñʽµÄÎļþ°É£¿
ÎÒÊǰÑh·ÅÔÚxmlDoc1ÀÓÃxmlDoc1.loadXML(h)£¬È»ºóÈ¡xmlDo ......
ÎÒµÄÒªÇóÊÇ£ºÍ¨¹ýץȡ±ðµÄ³ÌÐòÉϵıí¸ñµÄ¾ä±ú£¬È»ºó¶ÁÈ¡Õâ¸ö±í¸ñµÄÄÚÈÝ¡£
±í¸ñ¾ä±ú£¨ÀàÃû£ºMSFlexGridWndClass£©ÎÒÒÑ×¥µ½£¬½ÓÏÂÀ´ÈçºÎ¶ÁÈ¡±í¸ñµÄÄÚÈݾͲ»»áÁË£¿ÇóÖú¡£
ÄܰѴúÂë·¢À´Ñ§Ï°Ï²»£¿
244326867@qq.com ......
ÏÖÔÚСµÜÔÚÓÃvb6.0±àд³ÌÐò£¬Óöµ½Òì²½µÄÎÊÌ⣬¾ßÌåÈçÏ£º
µã»÷°´Å¥Aʱ£¬µ÷ÓÃÍⲿµÄdll(C++)£¬´ËdllÊÇͬ²½·µ»ØÊý¾Ý¡£´ËʱÈç¹ûÔ¶³ÌδÏìÓ¦£¬ÎҵijÌÐò½çÃæ¾Í»á¿¨ËÀ¡£Òò´ËÎÒÏëµ½ÓÃtimerÀ´ÊµÏÖÒì²½ £¬µ«ÊDz»Çå³þ¾ßÌåµÄÊµÏ ......