excelת»»xmlµÄϸ½ÚÎÊÌâ
ÎÒÒªÔÚwindows´°ÌåÏÂÉè¼ÆÒ»¸ö¶ÁÈ¥excelÎļþ²¢×ª»»³ÉxmlÎļþ.
ÏÖÔڴ󲿷ֹ¦Äܶ¼ÊµÏÖÁË,µ«³öÏÖÁ˺ܴóµÄÎÊÌâ....
ÏÖÔÚÎÒµÄexcelÎļþ°üº¬ÒÔÏÂÄÚÈÝ:
±àºÅ ÐÕÃû ѧ·Ñ ÔÓ·Ñ
001 a 54 65
002 b 78
003 c 44
ÎÒ°ÑÉÏÃæµÄexcelÎļþµ¼ÈëdatasetÖÐ,ÔÙдÈëxml,µÃµ½ÈçϽá¹û:
- <NewDataSet>
- <Table>
<񅧏>001 </񅧏>
<ÐÕÃû>a </ÐÕÃû>
<ѧ·Ñ>54 </ѧ·Ñ>
<ÔÓ·Ñ>65 </ÔÓ·Ñ>
</Table>
- <Table>
<񅧏>002 </񅧏>
<ÐÕÃû>b </ÐÕÃû>
<ÔÓ·Ñ>78 </ÔÓ·Ñ>
</Table>
- <Table>
<񅧏>001 </񅧏>
<ÐÕÃû>a </ÐÕÃû>
<ѧ·Ñ>44 </ѧ·Ñ>
</Table>
</NewDataSet>
ÎÊÌâ³öÏÖÁË,ÔÚxmlµÚ¶þ¸öºÍµÚÈý¸ötable½ÚµãÏÂ,ÓÉÓÚexcelÔÊý¾ÝΪ¿Õ,Òò´ËÔÚdatasetÖÐÊý¾ÝҲΪ¿Õ,ÓÚÊÇxmlÖÐÒ²¾ÍûÓÐÁËÏàÓ¦µÄ½Úµã,ÎÒûÓÐÉè¼ÆxmlµÄ¸ñʽģ°æ,Ö»ÓÃÁËds.WriteXml(filename)µÄ·½·¨.
ÏÖÔÚÎÒÏëÎÊÒ»ÏÂ,ÔõÑù²ÅÄÜʹxmlµÚ¶þ¸öºÍµÚÈý¸ötable½ÚµãϵÄÏÔʾ¸ñʽͬµÚÒ»¸öÒ»Ñù??
ÈËÄØ???....
......
Ïà¹ØÎÊ´ð£º
XML¶ÔÏóÓëXMLList¶ÔÏóÓÐÊ²Ã´Çø±ð£¿[
¹ËÃû˼Ò壬XMLList¾ÍÊÇÒ»¸öLIST£¬ÊÇÒ»¸ö¼¯ºÏ¡£
List °üº¬XMLÖеÄËùÓÐÔªËØ£¬ÓÃList¿ÉÒÔ·ÃÎÊXML¸ùÔªËØÏµÄ×ÓÔªËØ
ÒýÓÃ
List °üº¬XMLÖеÄËùÓÐÔªËØ£¬ÓÃList¿ÉÒÔ·ÃÎÊXML¸ùÔª ......
ÒÔÏ´úÂëÔÚIEÏÂÊÇ¿ÉÒÔÕý³££¬µ«ÊÇÓÃNETBOX·â×°¾Í²»ÐÐÁË£¬ÔËÐе½ºìÉ«µÄµØ·½¾Í³ö´íÁË£¬ËµÈ±ÉÙ¶ÔÏñ£¬ÇëÎÊÔõôÑùÐ޸ġ£
JScript code:
//////////////////// AJAXÀà////////////////
function getxml ......
ÎÒµÄXMLÅäÖÃÎļþÀïÃæÓÐÖÐÎÄ×Ö·û,Ò²ÓÐÀàËÆÓÚ=~@!ÕâÖÖ×Ö·û,encodeingÉèÖÃΪgb2312 ºÍ unicode,unicode UTF-8,½á¹û¶¼Ìáʾϵͳ´íÎó,,,Èç¹ûÉèÖÃΪgb2312µÄ»°,È¥µô=!@ÕâÖÖ×Ö·û,Ò»Çж¼Õý³£.
ÓÉÓÚÎ ......
1.xml
<shandong dn="day">
<city cityX="236" cityY="90" cityname="±õÖÝ" />
<city cityX="296" cityY="90" cityname=& ......