OWC11 Excel programming, where's info?

[Guest]

I am trying to create an excel spreadsheet from my asp.net(vb.net) page. I
can do this, but I just cannot find much documentation or code samples
online. There is some for very common tasks, but I can't get a lot of things
to work. I would think that I could pretty much do anything excel can do
from my code. Here are some examples: Freeze Panes, Password Protect a
worksheet, set Wrap Text on a cell, rotate text orientation 90 degrees in a
cell, . . .

Does anyone have any good documentation? Has anyone done much of this type
programming in asp.net?

 

[bruce barker \(sqlwork.com\)]

it not recommend to use owc from asp.net as there are scaling issues.

also you need to keep good track of your com references and call
Marshal.ReleaseComObject on all objects. never use double dot notation or
you can not release the object.


-- bruce (sqlwork.com)