Converting XSD file to XLS with full expansion of complex datatypes

See more:

XML

Hi,

I have an XSD file and the data types of an element may involve a namespace defined in an another XSD file.

I want the element name and the datatype of it in an excel file. The namespace defining the data type in other file should also be resolved to show the primitive data type (defined in the namespace) in an excel

<xs:complexType name="DBStatusType">
        <xs:sequence>
            <xs:element ref="DB:Version"/>
            <xs:element ref="DB:State"/>
            <xs:element ref="DB:StateReasons" minOccurs="0"/>
            <xs:element name="DBState1" type="DbStatus:DBStateType" minOccurs="0"/>
            <xs:element name="Session" minOccurs="0">
                <xs:complexType>
                    <xs:sequence>
                        <xs:element name="SessionInfo" type="DBSession:DBSessionInfoType" maxOccurs="unbounded"/>
                    </xs:sequence>
                </xs:complexType>
            </xs:element>
        </xs:sequence>
    </xs:complexType>

Here DBStatus and DBSessions are namespaces. They refer to a different XSD file.
I want the expansion of this datatype when the DBState1 & SessionInfo will be logged in the excel file

Do we have any tool for the same. I am new to the XML stuff

Thanks,
SL