Excel 2007/Style Sheets
 

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.

Excel 2007/Style Sheets
 

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


--
__________________________________
HTH

Bob

"sheila4typing" wrote in message
...
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.

Excel 2007/Style Sheets
 

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
on how to open the file and not sure which one to select. Open as an XML
table, As a read-only workbook, or Use the XML Source task pane?


"Bob Phillips" wrote:

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


--
__________________________________
HTH

Bob

"sheila4typing" wrote in message
...
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.