Excel 2007/Style Sheets

[sheila4typing]

I am hoping I am in the correct forum.
I have been asked at work to figure out how to use Excel and Style Sheets
with XML. I am not sure if I said that correctly or even understand, however
I was told this, "Since your data can be output in XML, I think you are a leg
up on moving forward. XML Stylesheets provide a mechanism for filtering raw
XML data and making it more presentable for end-user consumption". Hopefully
that makes since to you. Basically I have a website that I can export data
as XML and how to get to a style sheet from there I do not know, that is the
first part for existing data. Then we need to use excel to create, I believe
is the correct word syle sheets, this I do not know how to do. Can anyone
help? Sorry if I am confusing you; however I am confused myself.

 

[Bob Phillips]

If you open an XML file in Excel, you can get Excel to generate an XSD file
automatically with

?Print ActiveWorkbook.XMLMaps(1).Schemas(1).xml

 

[sheila4typing]

Thank you for your reply.
Sorry I am a little lost regarding what you are saying. Was is XSD file
automatically with ?Print ActiveWorkbook.XMLMaps(1).Schemas(1).xml?
I did what you said and when I tried to open in Excel 2007 I had 3 choices