How do you launch an existing spreadsheet using OWC?

[john.kaye]

I would like to display an existing excel spreadsheet as part of a web
page. I can find the ClassID for the OWC but cannot find the PARAM
names I need to get it to display the spreadsheet. Can you help me?

 

[Alvin Bruney - ASP.NET MVP]

The classid is sufficient to cause the spreadsheet to display. Make sure
your component is correctly registered and installed.

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[john.kaye]

Alvin, Thanks for the advice. The problem I had was I did not have a
datatype parameter - once that was set to XMLURL, the XML version of
the spreadsheet displayed.

Is there a datatype for an Excel file stored in XLS format?
Also, is it posible control the view scale to zoom out to show the
entire spreadsheet?

 

[Alvin Bruney - ASP.NET MVP]

There is no specific data type. To zoom, you can use the top and left
properties and set them appropriately. There is an undocument bug with
setting these options and borders that may cause the spreadsheet to behave
funky by the way.(FYI)

--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006

 

[john.kaye]

I cannot find documentation on the top & left properties and so cannot
set them.

My current code is:
<object id=Spreadsheet1
classid=CLSID:0002E559-0000-0000-C000-000000000046 style="height:350>
<PARAM NAME="DataType" VALUE="XMLURL">
<PARAM NAME="XMLURL" VALUE="http://path/filename.xml">
<PARAM NAME="ViewableRange" VALUE="b1:d4">
<PARAM NAME="Autofit" VALUE="True">
</OBJECT>

The component is opening up the spreadsheet but ignoring the autofit
and viewablerange parameters. Can you tell me what am I doing wrong?

 

[Alvin Bruney - ASP.NET MVP]

use
document.all.sp.style. either left or top or height can go here


--
Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The Microsoft Office Web Components Black Book with .NET
Now Available @ www.lulu.com/owc
Forth-coming VSTO.NET - Wrox/Wiley 2006