XML schema specifying transformation
I have generated an XSD
file for an XML
file and it's working when I am exporting data from Excel.
I would like to know if it's possible to specify the XSL
file in the Schema itself, so that when the XML
file 开发者_StackOverflowis created, the XSL
is already assigned to it.
Is that even possible? Or do I have to do it through Excel VBA code (which I really don't want)?
Thanks in advance,
Yusuf
If by "assign" an XSLT stylesheet you mean adding a PI to the XML document, then the answer would be that you have to do it with VBA code (or any second step tool, as XSLT itself). I don't see this option when exporting an Excel to XML.
That sounds strange. The point is that you may have different XSL transforms for each schema, to create different outputs from the same XML.
精彩评论