Convert XML to CSV using XSLT
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.
精彩评论