Viewing XML with Excel..Need XSD

[djtech2k]

I was suggested to post this question in this forum.

Here is the original:

http://www.tek-tips.com/viewthread.cfm?qid=1519242

I need to analyze xml data within Excel from output of a tool called admodify. There is a sample in that post. Anyway, The XSD that is created by Excel does not display the data how I need it to be. I have tried many tim4es to create an XSD, but it does the same.

Any ideas?

 

[xlhelp]

Is this what you are looking for?

<xsd:schema xmlns:xsd="[URL unfurl="true"]http://www.w3.org/2001/XMLSchema"><xsd:element[/URL] nillable="true" name="MailboxRights"><xsd:complexType><xsd:sequence minOccurs="0"><xsd:element minOccurs="0" maxOccurs="unbounded" nillable="true" name="user" form="unqualified"><xsd:complexType><xsd:sequence minOccurs="0"><xsd:element minOccurs="0" nillable="true" name="Inherited" form="unqualified"><xsd:complexType><xsd:sequence minOccurs="0"><xsd:element minOccurs="0" maxOccurs="unbounded" nillable="true" name="Entry" form="unqualified"><xsd:complexType><xsd:attribute name="Trustee" form="unqualified" type="xsd:string"></xsd:attribute><xsd:attribute name="Mask" form="unqualified" type="xsd:string"></xsd:attribute></xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element><xsd:element minOccurs="0" nillable="true" name="NotInherited" form="unqualified"><xsd:complexType><xsd:sequence minOccurs="0"><xsd:element minOccurs="0" maxOccurs="unbounded" nillable="true" name="Entry" form="unqualified"><xsd:complexType><xsd:attr
ibute name="Trustee" form="unqualified" type="xsd:string"></xsd:attribute><xsd:attribute name="Mask" form="unqualified" type="xsd:string"></xsd:attribute></xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element></xsd:sequence><xsd:attribute name="UserDN" form="unqualified" type="xsd:string"></xsd:attribute></xsd:complexType></xsd:element></xsd:sequence></xsd:complexType></xsd:element></xsd:schema>

in that case I am at Canadian Yahoo. add wrd to the handle and remove the e. Post here to let me know. Else, ....pls post when you find the answer.

Vita Brevis

 

[djtech2k]

That does not seem to work. I imported that into Excel and then tried to import my xml data ans it says it doesnt match up. Also, when I just put in that xsd as a map in Excel, the columns do not nook how I need it to. I need columns like:

UserDN, Inherited/Not Inherited, Trustee, Mask