XML到CSV的转换 [英] XML to CSV conversion

问题描述

嗨
我正在尝试按节点值将xml文档转换为CSV文件，例如



这是我的示例xml文件

 <   account  >  
 <   feild1  >  aaaaa <   / feild1  >  
 <   feild2  >  aaaaa <   / feild2  >  
 <   feild3  >  aaaaa <   / feild3  >  
 <   feild4  >  aaaaa <   / feild4  >  
 <  产品 >  
 <   product  >  
 <  < span class =code-leadattribute> feild1  >  bbbb <   / feild1  >  
 <  < span class =code-leadattribute> feild2  >  bbbb <   / feild2  >  
 <   feild3  >  bbbb <   / feild3  >  
 <   feild4  >  bbbb <   / feild4  >  
 <   / product  >  
 < span class =code-keyword><   / products  >  
 <  人员 >  
 <   person  >  
 <   feild1  >  cccccc <   / feild1  >  
 <   feild2  >  cccccc <   / feild2  >  
 <   feild3  >  cccccc <   / feild3  >  
 <   feild4  >  cccccc <   / feild4  >  
 <   / person  >  
 <   / persons  >  
 <   / account  >  

i需要以excel显示输出为

 account aaaa aaaa aaaa aaaa 
 product bbbb bbbb bbbb bbbb 
 person cccc cccc cccc cccc 

作为CSV文件

解决方案

我会使用XSLT。



http://www.w3schools.com/xsl/default.asp [ ^ ]

那你到目前为止尝试了什么。我们不打算为你做功课。向我们展示您遇到问题的代码片段，我们很乐意为您提供帮助。

我们不为您做作业的原因：对JSOP的赞美 [ ^

Hi I am trying to convert xml document to CSV file by node value for e.g

this is my sample xml file

<account>
   <feild1>aaaaa</feild1>
   <feild2>aaaaa</feild2>
   <feild3>aaaaa</feild3>
   <feild4>aaaaa</feild4>
<products>
  <product>
    <feild1>bbbb</feild1>
    <feild2>bbbb</feild2>
    <feild3>bbbb</feild3>
    <feild4>bbbb</feild4>
  </product>
</products>
<persons>
  <person>
    <feild1>cccccc</feild1>
    <feild2>cccccc</feild2>
    <feild3>cccccc</feild3>
    <feild4>cccccc</feild4>
  </person>
</persons>
</account>

i need to display the output in excel as

account aaaa aaaa aaaa  aaaa 
product bbbb bbbb bbbb  bbbb
person  cccc cccc cccc  cccc

as a CSV File

解决方案

I''d use XSLT.

http://www.w3schools.com/xsl/default.asp[^]

So what have you tried so far. We''re not going to do your homework for you. Show us code snippets where you have problems and we''ll be happy to help.
The reason we don''t do homework for you: Compliments of JSOP[^]

这篇关于XML到CSV的转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！