XML conversion to execl I want to convert the XML file generated by PHP to execl table representation & nbsp; for example, my xml is XMLcode & lt; subject & gt; BasicInformation & lt; question & gt; Whatisyourage? & Lt; answer & gt; 8-12 & lt; answer & gt; & lt; convert XML to EXECL
I want to convert the XML file generated in PHP to execl table representation.
For example, my xml is
XML code
Basic Information
What is your age? 8-12
2
0.01%
13-19
43
0.31%
20-34
65
0.47%
35-49
24
0.18%
50+
3
0.02%
What is your gender? Male
119
0.87%
Female
18
0.13%
When this sub-statement is represented in EXECL
Only the last layer of data is displayed, that is, answer count and ratio. the content of question is not displayed, and the answer count ratio data is not in the corresponding row.
How can I display XML data properly under the guidance of a person?
------ Solution --------------------
Your code?
------ Solution --------------------
EXECL has its own format. you can only convert it to execl format to open it.
------ Solution --------------------
Phpwind splits the xmlfield, and then the output x.csv can be opened in excel.