Basic Framework for importing data from XML to excel, basic framework of xmlexcel
XML is used for data transmission of WEBserivce during project creation. When the data volume is large, it is troublesome to analyze the obtained data. After importing the data to Excel, you can easily process data.
The basic format is as follows:
<? Xml version = "1.0" encoding = "UTF-8"?>
<SOAP: Envelope xmlns: SOAP = "http://schemas.xmlsoap.org/soap/envelope/">
</SOAP: Envelope>
Let's take another example. You can use import directly.
1. Download the test document.
3. xml: http://download.csdn.net/detail/leejianxue/9066343
<? Xml version = "1.0" encoding = "UTF-8"?>
<SOAP: Envelope xmlns: SOAP = "http://schemas.xmlsoap.org/soap/envelope/">
<NewDataSet> <Table1> <Lgnum> 33 </Lgnum> <Tbnum> 33 </Tbnum> <Tbpos> 0000 </Tbpos> <Matnr> 33 </Matnr> <Werks> 33 </Werks> <Charg> 33333333 </Charg> <Lgort> 0012 </Lgort> <Menga> 2.000 </Menga> <Altme> GE </Altme> <Maktx> replace </Maktx> <Vltyp> 922 </Vltyp> <Vlpla> 333 </Vlpla> <Bwlvs> 309 </Bwlvs> <Trart> </Trart> <Nltyp> </Nltyp> <Nlpla> </Nlpla>
</SOAP: Envelope>
Ii. data used in EXCEL = "other data sources => import from XML data source. Select 3. xml. The following message is displayed. OK.
Iii. Result: if the number of data records exceeds 1, the data format is displayed, that is, the header. If there is only one record, it seems that only the data is displayed and there is no header field.
Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.