OWC: How load a correct schema into XmlData

[Luca]

Hi all,

I'm trying to build an aspx page containing a OWC spreadsheet in order to
show some data. The idea is to apply an xsl well formed schema to an xml
obtained from a dataset.

After found some resources on the web and after saved and analyzed an excel
sheet in xml format I was able to create a stylesheet and apply it to an xml.
In fact I'm able to open the xml file in excel and see the sheet formatted
as I like.

The problem is when I try to pass the result of the trasformation to the owc
XmlData parameter. In fact during the componet's loading phase I obtain the
following error: 'An Xml Spreadsheet Document must contain a workbook as its
root node' but the document starts with the workbook tag !!

Where do I wrong?

Thanks
luca

 

[Luca]

P.S: the string I pass to XmlData is the follow:

<Workbook
xmlns:msxsl='urn:schemas-microsoft-com:xslt'
xmlns:user='urn:my-scripts'
xmlns:c='urn:schemas-microsoft-comffice:component:spreadsheet'
xmlns='urn:schemas-microsoft-comffice:spreadsheet'
xmlns='urn:schemas-microsoft-comfficeffice'
xmlns:x='urn:schemas-microsoft-comffice:excel'
xmlns:ss='urn:schemas-microsoft-comffice:spreadsheet'
xmlns:html='http://www.w3.org/TR/REC-html40'>
<Styles> ........