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×Ö·û´®¸ñʽ£ ......
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
<B>
<C>
</C>
&nb ......
ÇëÎÊ.netÈçºÎ¶ÁÈ¡xmlµÄÖµ дµ½Êý¾Ý¿â Ï£Íû¸ø³öÍêÕûµÄ´úÂë лл
<?xml version="1.0" encoding="utf-8" ?>
- <channel>
- <item>
......
×¢£º
1.ÊÖ¶¯É¾³ýieÁÙʱÎļþºó¿ÉÒÔ»ñÈ¡ÐÂÊý¾Ý£»
2.Ë¢ÐÂÒ³Ãæ²»ÄÜ»ñÈ¡ÐÂÊý¾Ý£»
3.²»ÒªËµ¼ÓËæ»úÊýÔÚurlÉÏ£¬ÎÒ²»ÖªµÀ¾ßÌå¼ÓÔÚÄÄÀÎÒÂÒÊÔÁËÒ²»¹ÊDz»ÐУ»
4.Ï£ÍûµÃµ½µÄЧ¹ûÊǵã»÷¡°»ñÈ¡Êý¾Ý¡±ºó¿ÉÒÔÏÔʾxmlÀï ......
<?xml version="1.0" encoding="gb2312"?>
<!DOCTYPE treeview SYSTEM "treeview.dtd">
<?xml-stylesheet type="text/xsl" href="treeview.x ......