开发者

Convert XML to CSV using XSLT

开发者 https://www.devze.com 2023-01-22 04:37 出处:网络
How to convert XML to CSV (to be shown in Excel file) using XSLT? Provided开发者_开发技巧 XML value itself contains comma, e.g.

How to convert XML to CSV (to be shown in Excel file) using XSLT?

Provided开发者_开发技巧 XML value itself contains comma, e.g.

<name>The,Bad Boy</name>

My logic considers "The" & "Bad boy" as separate values as it goes in different columns after opening in Excel file.


It's not that this type of question would not have been answered before:

  • Transform xml structure to another xml structure with xslt
  • XML to CSV Using XSLT
  • How can we convert XML file to CSV?
  • XML to CSV using XSLT help

By the way, "CSV" does not mean that values cannot contain commas or must be separated by commas.

Excel can understand CSV that is separated by other characters than comma (tab, for example), and values that contain the separator can be enclosed in quotes.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号