EXCEL转换XML?
EXCEL怎么转换成其他软件提供的标准XML格式? 直接用EXCEL2003可以实现还是用写程序转换?
需要格式如下:求代码例
<?xml version="1.0" encoding="gb2312" ?>
<ufinterface sender="000" receiver="u8" roottag="storein" docid=".3048" proc="Query" codeexchanged="N" exportneedexch="N" paginate="0" display="入库单" family="库存管理" timestamp="0x000000000022ABB9">
<storein>
<header>
<id />
<receiveflag>1</receiveflag>
<vouchtype>10</vouchtype>
<businesstype>成品入库</businesstype>
<source>仓库</source>
<businesscode />
<warehousecode>0101</warehousecode>
<date>2009-12-16</date>
<code>20091200001</code>
<vendorcode />
<ordercode />
</header>
<body>
<entry>
<id />
<barcode />
<inventorycode>AA001</inventorycode>
<quantity>3050.00</quantity>
</entry>
<entry>
<id />
<barcode />
<inventorycode>DAA0500729</inventorycode>
<quantity>3000.00</quantity>
</entry>
</storein>
</ufinterface>