EXCEL转换成XML
有一个问题困扰我好几天了,求大神指点我现在需要把一个EXCEL按一个XML模版的格式转换成对应的XML
excel部分内容如下,表完全没有按照单元格去填
*** PURCHASE ORDER *** INVOICE TO: *** PURCHASE ORDER ***
Hardee County School Board
P.O. Box 1678
Wauchula, FL 33873
Phone: 863-773-9058 Fax: 863-773-4673
SHOW PO NUMBER ON ALL SHIPPING CONTAINERS, PO NUMBER: 12F-000099
PACKING LISTS, INVOICES AND CORRESPONDE PO DATE: 08/01/2011
VENDOR: ULLRICHS PITCHER PUMP 2731 PAGE: Page 1 of 1
PO AMOUNT: 4,800.00 TIMES PRINTED: 3
STATUS AND DATE: Reencumbered 01/12/2012 PO EXPIRES: 10/30/2011
ULLRICHS PITCHER PUMP 2731 SHIP TO: FOOD SERVICE - CENTRAL
WATER CONDITIONING SERVICE
1009 NORTH 6TH AVENUE
409 GOOLSBY STREET
Wauchula FL 33873
Wauchula FL 33873
United States
United States
PHONE: (863)773-9058 FAX: (863)773-0069
EMAIL:
ATTENTION: Barbara Jernigan
DELIVERY DATE: 8/1/2011
<?xml version="1.0" encoding="utf-8" ?>
<PO_Data 01/08/2011>
<Vendors>
<Vendor Vendor_Number="">
<Name1></Name1>
<Name2></Name2>
<Contact></Contact>契约
<Phone></Phone>
<Address1></Address1>
<Address2></Address2>
<Address3></Address3>
<City></City>
<State></State>
<Zip></Zip>
<Country></Country>
<Category></Category>
<DUNS></DUNS>
<Misc>
<Field1></Field1>领域
<Field2></Field2>
<Field3></Field3>
</Misc>
</Vendor>
</Vendors>
<POs>
<PO_Data 01/08/2011>
<Vendors>
<Vendor Vendor_Number="">
<Name1></Name1>
<Name2></Name2>
<Contact></Contact>契约
<Phone></Phone>
<Address1></Address1>
<Address2></Address2>
<Address3></Address3>
<City></City>
<State></State>
<Zip></Zip>
<Country></Country>
<Category></Category>
<DUNS></DUNS>
<Misc>
<Field1></Field1>领域
<Field2></Field2>
<Field3></Field3>
</Misc>
</Vendor>
</Vendors>
<POs>
求大神指点啊,给点思路,最好详细点,不胜感激