Hi Alvin,
The issue we run into is that the ''sst" in "sst.DisplayColHeaders" returns an “Object doesn’t support this property or method: ‘sst.DisplayColHeaders’â€. This happens for most of
Here is the code that instantiates the spreadsheet part and the code that fails is the vbscript directly below it.
-------------------------
<OBJECT id=sst style="LEFT: 10px; WIDTH: 587px; TOP: 34px; HEIGHT: 72px"
classid=clsid:0002E559-0000-0000-C000-000000000046 width=587 height=72><PARAM NAME="HTMLURL" VALUE=""><PARAM NAME="HTMLData" VALUE="<html xmlns:x="urn:schemas-microsoft-com
ffice:excel"
xmlns="
http://www.w3.org/TR/REC-html40">
<head>
<style type="text/css">
<!--tr
{mso-height-source:auto;}
td
{white-space:nowrap;}
.wc899483B
{white-space:nowrap;
font-family:Arial;
mso-number-format:General;
font-size:auto;
font-weight:auto;
font-style:auto;
text-decoration:auto;
mso-background-source:auto;
mso-pattern:auto;
mso-color-source:auto;
text-align:general;
vertical-align:bottom;
border-top:none;
border-left:none;
border-right:none;
border-bottom:none;
mso-protection:locked;}
-->
</style>
</head>
<body>
<!--[if gte mso 9]><xml>
<x:ExcelWorkbook>
<x:ExcelWorksheets>
<x:ExcelWorksheet>
<x:OWCVersion>9.0.0.3821</x:OWCVersion>
<x:Label Style='text-underline-style:none;background:black;color:white;
border-top:solid .5pt silver;border-left:solid .5pt silver;border-right:
solid .5pt silver;border-bottom:solid .5pt silver'>
<x:Caption>Assignments</x:Caption>
</x:Label>
<x:Name>Sheet1</x:Name>
<x:WorksheetOptions>
<x:Selected/>
<x:Height>1905</x:Height>
<x:Width>15531</x:Width>
<x:TopRowVisible>0</x:TopRowVisible>
<x:LeftColumnVisible>0</x:LeftColumnVisible>
<x
rotectContents>False</x
rotectContents>
<x
efaultRowHeight>255</x
efaultRowHeight>
<x:StandardWidth>2340</x:StandardWidth>
</x:WorksheetOptions>
</x:ExcelWorksheet>
</x:ExcelWorksheets>
<x:MaxHeight>100%</x:MaxHeight>
<x:MaxWidth>100%</x:MaxWidth>
</x:ExcelWorkbook>
</xml><![endif]-->
<table class=wc899483B x:str>
<col class=wc899483B width="64">
<tr height="17">
<td class=wc899483B></td>
</tr>
</table>
</body>
</html>
"><PARAM NAME="DataType" VALUE="HTMLDATA"><PARAM NAME="AutoFit" VALUE="0"><PARAM NAME="DisplayColHeaders" VALUE="0"><PARAM NAME="DisplayGridlines" VALUE="-1"><PARAM NAME="DisplayHorizontalScrollBar" VALUE="-1"><PARAM NAME="DisplayRowHeaders" VALUE="0"><PARAM NAME="DisplayTitleBar" VALUE="0"><PARAM NAME="DisplayToolbar" VALUE="0"><PARAM NAME="DisplayVerticalScrollBar" VALUE="-1"><PARAM NAME="EnableAutoCalculate" VALUE="-1"><PARAM NAME="EnableEvents" VALUE="-1"><PARAM NAME="MoveAfterReturn" VALUE="0"><PARAM NAME="MoveAfterReturnDirection" VALUE="0"><PARAM NAME="RightToLeft" VALUE="0"><PARAM NAME="ViewableRange" VALUE="1:1000"></OBJECT><script LANGUAGE="vbscript"><!--
sst.AutoFit = true
sst.DisplayColHeaders = False
sst.DisplayRowHeaders = False
--></script>
---------------------------
All the best,
Ron
----- Alvin Bruney wrote: -----
do you have any owc9.dll or owc10.dll's on your system? if you do, run a
regsvr32 -u on them
Previously you said "You would need to remove the old owc10 reference in
your project and add a new reference to the owc11 library so that when you
call create on the object, it points to the owc11 library and not owc10
library."That's a brainfart on my part. I thought this was server code for a moment.
If the CLSID for the OWC points to owc11 object and you have it registered
correctly. It will work. What is the problem you are experiencing? Is it in
read only mode?
--
Regards,
Alvin Bruney
Got DotNet? Get it here
http://home.networkip.net/dotnet/tidbits/default.htm
your project and add a new reference to the owc11 library so that when you
call create on the object, it points to the owc11 library and not owc10
library."am pretty sure the OWC SpreadSheet component is being called. However, there
are a number of license manager references with its CLSID. I even tried
updating the lpk file to include OWC11.
