XML Schema

[Bob]

Hi,

I am looking for the XML Schema for Spreadsheet and Chart (OWC 10). I feel
like I have wandered far and wide and have come up empty. I inherited a
bouch of work (ASPs pulling data from SQL Server and embedding XML for OWC).
I have figured a lot out from the exisiting code base, and from creating
something in Excel and saving it as XML/HTML, but would sure like to find a
reference.

Please help
I feel like I am taking crazy pills.

 

[Alvin Bruney [MVP]]

start by telling us exactly what you are trying to accomplish

 

[JohnFol]

Hi Bob, I think I know where you are coming from.

A chart can be populated using XML data. It wasn't clear to me what the
rules were for the structure of the XML so I looked through some of the
online examples. I found the following

http://support.microsoft.com/kb/303016/EN-US/

Alvin, I think what Bob is asking (and me for that matter) is "is there a
defined schema defining what the XML structure needs to be to populate the
OWC controls?"

Bob, tell me if this is wrong.

start by telling us exactly what you are trying to accomplish

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi,

I am looking for the XML Schema for Spreadsheet and Chart (OWC 10). I
feel
like I have wandered far and wide and have come up empty. I inherited a
bouch of work (ASPs pulling data from SQL Server and embedding XML for
OWC).
I have figured a lot out from the exisiting code base, and from creating
something in Excel and saving it as XML/HTML, but would sure like to find
a
reference.

Please help
I feel like I am taking crazy pills.

 

[Bob]

JohnFol is correct. I am just looking for a reference to the XML schema.
There is a pretty decent document on SpreadsheetML but haven't found a
similar document for Chart.
I guess I'm just an old geezer who lifes good old fashioned reference manuals.

Hi Bob, I think I know where you are coming from.

A chart can be populated using XML data. It wasn't clear to me what the
rules were for the structure of the XML so I looked through some of the
online examples. I found the following

http://support.microsoft.com/kb/303016/EN-US/

Alvin, I think what Bob is asking (and me for that matter) is "is there a
defined schema defining what the XML structure needs to be to populate the
OWC controls?"

Bob, tell me if this is wrong.

start by telling us exactly what you are trying to accomplish

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi,

I am looking for the XML Schema for Spreadsheet and Chart (OWC 10). I
feel
like I have wandered far and wide and have come up empty. I inherited a
bouch of work (ASPs pulling data from SQL Server and embedding XML for
OWC).
I have figured a lot out from the exisiting code base, and from creating
something in Excel and saving it as XML/HTML, but would sure like to find
a
reference.

Please help
I feel like I am taking crazy pills.

 

[Alvin Bruney [MVP]]

The components cannot load ordinary XML. The xmlschema must be formatted
with specail header and footer tags and workbook tags for the spreadsheet
and pivot table. The easiest way to load spreadsheet xml is to slap on the
workbook start and end tags to the existing ordinary xml document. Same for
the chart.

If you need to see what the schema looks like, load some data into the
specific control and write it out to a file. Then open the file and compare
it to an ordinary XML file to determine which portions must be added. For
the most part, it is the start and end tags.

There is no documentation available that i know of. I learned it the hard
way as explained above.
--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi Bob, I think I know where you are coming from.

A chart can be populated using XML data. It wasn't clear to me what the
rules were for the structure of the XML so I looked through some of the
online examples. I found the following

http://support.microsoft.com/kb/303016/EN-US/

Alvin, I think what Bob is asking (and me for that matter) is "is there a
defined schema defining what the XML structure needs to be to populate the
OWC controls?"

Bob, tell me if this is wrong.

start by telling us exactly what you are trying to accomplish

--
Regards,
Alvin Bruney
[ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
Got tidbits? Get it here... http://tinyurl.com/27cok

Hi,

I am looking for the XML Schema for Spreadsheet and Chart (OWC 10). I
feel
like I have wandered far and wide and have come up empty. I inherited
a
bouch of work (ASPs pulling data from SQL Server and embedding XML for
OWC).
I have figured a lot out from the exisiting code base, and from
creating
something in Excel and saving it as XML/HTML, but would sure like to find
a
reference.

Please help
I feel like I am taking crazy pills.