|
|
Rank: Advanced Member
Joined: 1/23/2016
Posts: 54
|
Hi,
how to transform an XSD into XLSX (see below) ?
I have only XMLSpy 2012 Professional
Thanks a lot in advance,
Michel
element:
name -> column1
type -> column2
minOccours -> column3
maxOccours -> column4
javadoc -> column5
<xsd:complexType name="aaa">
<xsd:sequence>
<xsd:element name="xxx1 type="yyy1">
<xsd:annotation>
<xsd:appinfo>
<jaxb:property>
<jaxb:javadoc>... here text ...
</jaxb:javadoc>
</jaxb:property>
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
<xsd:element name="xxx2" type="yyy2>
<xsd:annotation>
<xsd:appinfo>
<jaxb:property>
<jaxb:javadoc>... here text ...
</jaxb:javadoc>
</jaxb:property>
</xsd:appinfo>
</xsd:annotation>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
|
|
Rank: Newbie
Joined: 10/28/2002
Posts: 1,283
Location: AT
|
If you require schema documentation you can use the "Generate DTD/Schema" in the Schema Design menu of XML Spy. With this functionality you can generate schema documentation in HTML; WORD, RTF or PDF formats.
If you only have XML Spy, and if you MUST have an xlsx as output I would suggest the following:
1) write an xslt stylesheet to transform the xsd to a delimited text file
2) open the delimited text file in Excel then save as an xlsx.
Attached is a simple example of a handwritten xslt stylesheet "test.xslt". If you transform the attached "test.xsd" file with "test.xslt" you will end up with an output "test.txt" which can then be opened as a delimited text file in Excel and then saved as an xlsx.File Attachment(s):
 test.zip (2kb) downloaded 1,759 time(s).
|
|
Rank: Advanced Member
Joined: 1/23/2016
Posts: 54
|
Island,
thanks a lot for your effort !!!!
warm regards,
Michel
|
|
|
guest |
