ÇëÎÊVBÏÂÔØµ½EXCELÎÊÌâ - VB / ¿Ø¼þ
ÎÒÓиö³ÌÐòÊÇÓÃVB±àµÄ,Ö»ÓпÉÖ´ÐгÌÐò1,ûÓÐÔ´´úÂë,ËùÒÔÖ»ÄÜÓÃVBÁíÍâÔÙ×öÒ»¸ö³ÌÐò2,ÏÖÔÚÎÒÏë°ÑÁíÍâµÄ³ÌÐò2×ö³ÉÒ»¸ö°´Å¥,ÎÒÏëʵÏÖµÄÊÇ:
ÔÚ´ò¿ªÔÓгÌÐò1µÄij¸öÒ³ÃæÊ±,Ò»°´Õâ¸ö°´Å¥¾Í¿ÉÒÔ½«´ËÒ³ÃæµÄ±í¸ñ¿Ø¼þÀïµÄÄÚÈݵ¼Èëµ½EXCELÖÐ,
ÇëÎÊ´ó¼ÒÈçºÎʵÏÖ°¡?
Õâ¸öÄѶȱȽϴó£¬Ó¦¸Ã˵ÕâÑù×öЧ¹û²»¼Ñ¡£
ÓÑÇéUp.............
Õâ¸öÄѶȱȽϴó£¬Ó¦¸Ã˵ÕâÑù×öЧ¹û²»¼Ñ
objExcelSheet.Cells(lngRow, lngColumn
Ïà¹ØÎÊ´ð£º
DIM ds as new DataSet
ÎÒÕâÑùÉùÃ÷ ÔõÀÏÊDZ¨ Óû§¶¨ÒåÀàÐÍ䶨Ò壿 Õâ¸öÐèÒªÒýÓÃʲôÂ𣿣¿
ǰÌáÊÇDataSet¶ÔÏóÒª´æÔÚ,¾ÍÊǶÔÏóä¯ÀÀÆ÷ÖÐÓÐËü.ûÓоÍÒªÒýÓÃ.
datasetÊÇADO.NET¶ÔÏó
Èç¹ûÄãÓõÄÊÇvb.net£¬ÄÇôÔÚ´ ......
Private Sub Command1_Click()
Dim MyString() As String
Open "a.xml" For Binary As #1 ' ´ò¿ª¸Õ´´½¨µÄÎļþ¡£
ReDim MyString(LOF(1) - 1)
Put #1, , MyRecord ' ¶ÁÈëËùÓÐ×Ö·ûµ½±äÁ¿ÖÐ ......
xmlDoc1.loadXML(h)×ÜÊÇ·µ»Øfalse£¬ÎªÊ²Ã´£¿Ð»Ð»°ïæ»Ø´ðÒ»ÏÂ
hÊÇÊ²Ã´ÄØ¡£¡£¡£¡£¡£¡£¡£¡£¡£
hÊÇxml¸ñʽµÄ×Ö·û´®
ÄãÊÇÏë´ò¿ª¡£XML¸ñʽµÄÎļþ°É£¿
ÎÒÊǰÑh·ÅÔÚxmlDoc1ÀÓÃxmlDoc1.loadXML(h)£¬È»ºóÈ¡xmlDo ......
ÎÊÌ⣺
ÏÖÔÚAccessÊý¾Ý¿âÖÐÓÐÁ½ÕűíTableAºÍTableB
TableAÖÐÓмǼÈçÏÂ:
×Ö¶Î1(Name) ×Ö¶Î2(Num)
A 3
A 4
B 6
... ......