Community Learn Tools Library Leisure
search
English
Home > Backend Development > XML/RSS Tutorial > Import XML files into EXCEL

Import XML files into EXCEL

黄舟
Release： 2017-02-25 14:12:48
Original
2113 people have browsed it

1. Creation of XML (Extensible Markup Language) file 

<?xml version="1.0" 
encoding="utf-8"?>
<Item>
<a><SFZHM>370322200202</SFZHM><XM>张</XM><KH>C55796656</KH><TXDZ>山东省</TXDZ><YZBM>256300</YZBM><LXDH>1312886</LXDH><CWYYSM>公民不匹配</CWYYSM></a>
<a><SFZHM>370322200126</SFZHM><XM>张</XM><KH>C55797528</KH><TXDZ>山东省</TXDZ><YZBM>256300</YZBM><LXDH>13182886</LXDH><CWYYSM>公民不匹配</CWYYSM></a>
<a><SFZHM>370322200219</SFZHM><XM>闫</XM><KH>C55799232</KH><TXDZ>山东省</TXDZ><YZBM>256300</YZBM><LXDH>13181886</LXDH><CWYYSM>公民身份配</CWYYSM></a>
<a><SFZHM>3703222070238</SFZHM><XM>吕</XM><KH>C55802331</KH><TXDZ>山东省</TXDZ><YZBM>256300</YZBM><LXDH>1318886</LXDH><CWYYSM>上送证件有合法</CWYYSM></a>
</Item>
Copy after login

Description: The first line is the XML declaration, which defines the XML version (1.0) and the encoding used. The second line describes the root element of the document, and the last line defines the end of the root element. Any start tag must have an end tag.

2. Import into Excel

Import XML files into EXCEL

The above is the content of importing XML files into EXCEL. For more related content, please pay attention to the PHP Chinese website (m.sbmmt.com) !


Related labels：
excel xml File import
source：php.cn
Previous article：Semantics of XML tags Next article：XML Sitemap related questions
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
SimpleXML not loading GML data I have the following sample XML data that I want to parse to SimpleXML using PHP: <?xml...
From 2024-04-04 10:04:41
0
1
358
JP character error in title of XML RSS using simplexml_load_file() php PHP version: 7.4.30 I use simplexml_load_filephp function, $rss=simplexml_load_file($url,'...
From 2024-04-03 21:22:05
0
1
304
How to get all values ​​from database and return to PHP code in XML field? I need some help with my application. I have this code: realtime.php $jogador=Jogador::get...
From 2024-03-30 16:09:24
0
1
397
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template