How to import a XML spreadsheet into Office Web Components 11 shee

[AYTC]

How to import a XML spreadsheet into Office Web Components 11 spreadsheet.
We are trying to allow user the export the data in the OWC to a spreadsheet
in a external Excel windows. After the user finish editing the data in the
Excel windows, we want to import the spreadsheet back to OWC compoment. What
is the best way to do it?
The OWC is hosted in a VB6 form.

TIA.

Alex

 

[Alvin Bruney [MVP]]

use the xmldata property of the spreadsheet object

 

[AYTC]

Thanks for the reply.
We tried xmldata, but it ask for the xml schema which we don't have.
We later found out that xmlurl properties actually work with XML spreadsheet.
Problem solved.

Thanks.

use the xmldata property of the spreadsheet object

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

How to import a XML spreadsheet into Office Web Components 11 spreadsheet.
We are trying to allow user the export the data in the OWC to a
spreadsheet
in a external Excel windows. After the user finish editing the data in the
Excel windows, we want to import the spreadsheet back to OWC compoment.
What
is the best way to do it?
The OWC is hosted in a VB6 form.

TIA.

Alex