XML轉DataSet¡¢DataTable
ÎÒÏëÒªÒ»個ͨÓõÄxml轉DataTable£¬xmlÎļþ來×Ô²»Í¬µÄÎÄ檔£¬
ÀýÈ磺excelÎÄ檔Áí´æ為xmlÎÄ檔Ôõô°Ñ這個xmlÎÄ檔轉換³ÉDataSet¡¢DataTable,
ÒÔϾÍÊÇÎÒµÄXMLÎÄ檔£¬ÊÇͨ過excel轉µÄ£¬µ«ÊÇ轉DataTableÀÏÊÇʧ敗£¬讀²»µ½數據
XML code
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Created>1996-12-17T01:32:42Z </Created>
<LastSaved>2009-11-03T08:14:23Z </LastSaved>
<Version>11.5606 </Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
<RemovePersonalInformation/>
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>4530 </WindowHeight>
&nbs
Ïà¹ØÎÊ´ð£º
vbÖÐÔõôͨ¹ýxmlÀ´½âÎöÊý¾Ý¿âÖеÄ×Ö¶ÎÖµ¡£
û°ì·¨ÓÃXML½âÎöÊý¾Ý¿âµÄ×Ö¶ÎÖµ£¬³ý·ÇÊý¾Ý¿âÖб£´æµÄÊÇXML¸ñʽµÄ×Ö·û´®Îĵµ¡£
XMLÓÃÀ´Õ¹Ê¾²ã´ÎµÄÊý¾Ý¡£
Êý¾Ý¿âÒ»°ãÊǶþάÊý¾Ý¡£
Êý¾Ý¿âÖб£´æµÄÊÇXML×Ö·û´®¸ñʽ£ ......
ÐèÒª¼æÈÝie firefox safari µÈä¯ÀÀÆ÷
IE ¿ÉÒÔÓÃFSO µ«ÊÇÔÚÆäËûä¯ÀÀÆ÷²»ÄÜÓÃ
Ò»°ãµÄä¯ÀÀÆ÷´¦ÓÚ°²È«¿¼ÂǶ¼²»ÔÊÐíJavaScript¶Áд±¾µØÎļþµÄ°É
XMLÎĵµÄÚÈÝÈçÏ£¨user.xml£©£º
<?xml version="1.0&qu ......
Êý¾Ý¿â±íÖÐÓÐÒ»ÁУ¨TranXml£©ÀàÐÍÊÇxml£¬´æ´¢µÄÊÇÀàËÆ
<fathernode>
<a>aaa
</a>
<b>bbb
</b>
</fathernode>
µÄÐÅÏ¢£¬²¢ÇÒͨ¹ý²éѯ·½· ......
·µ»ØÈçÏÂxml×Ö·û´®£º
<?xml version="1.0" encoding="utf-8" ?>
<DeliverMsg xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www ......
<Employee>
<Employee code= "2003 ">
<a> fdsafdsaf </a>
......