Can you use the offset property with OWC10 spreadsheet object?

[Sean]

I have a web page that I designed with Studio .NET 2002 which uses the old
classid for the OWC spreadsheet object of
"CLSID:0002E510-0000-0000-C000-000000000046". I believe this is the classid
of the orginal OWC9, even though it works fine on machines with OWC10
installed and Office XP.

Since it has been a couple of years since I have updated this web page I
want to start using the classid for OWC10, which I believe is
"CLSID:0002E551-0000-0000-C000-000000000046".

When I update the classid the spreadsheet renders properly, however, some of
the script that I use to modify the spreadsheet no longer functions. For
example, the line MySS.Range("A1").Offset(1).InsertRows(1) generates the
"Object doesn't support this property or method:" error message.

Is the Offset property no longer used with this newer spreadsheet object?

I create the VBscript in the code behind page so that I can connect to SQL
data and loop through a data reader. Then, when I am done creating all of
the script I need I pass it to the HTML portion of the page using the Literal
tool. Not sure if this is the preffered method or not, but it seems to work.

Alvin Bruney, if you happen to read this, I have ordered your book. I read
the first chp and it looks like it might help me as I get back into using the
OWC. I also wanted to thank you for answering my post from yesterday.

Sean

 

[Alvin Bruney [Microsoft MVP]]

example, the line MySS.Range("A1").Offset(1).InsertRows(1) generates the

"Object doesn't support this property or method:" error message.

Yes, this functionality has been deprecated or moved to another object. If
memory serves me correctly, you can simply use the cells[x,y] property or
the insert/add method to accomplish the same.

I'd give an example but my laptop crashed taking with it my valuable code
base

I also wanted to thank you for answering my post from yesterday

No problemo.

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc