Posted to microsoft.public.excel.programming
|
|
Adding OLEObject--how to set object properties?
doesn't C# have "using" for this ?
http://msdn.microsoft.com/en-us/libr...02(VS.80).aspx
Tim
"Jeff Donkersgoed" wrote in
message ...
I used the following line to add a label (or textbox, etc.) to my
worksheet,
and I can see it in Excel.
Excel.OLEObject ole =
((Excel.OLEObjects)wsTemplate.OLEObjects(Missing.V alue)).Add("Forms.Label.1",
Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value,
Missing.Value, 15, 15, 100, 20);
The problem is that it just says "Label1" for the text. How can I go
about
changing it and the font as well? I can't figure out how to cast the
ole.Object to anything which is what I think I need to do.
I've see lots of VBA code that just uses "With" as below, but can I do
something similar in C#?
Dim Lbl As OLEObject
Set Lbl = ActiveSheet.OLEObjects.Add(ClassType:="Forms.Label .1",
Link:=False, _
DisplayAsIcon:=False, Left:=232.5, Top:=241.5, Width:=72, Height:=18)
With Lbl
.Name = "ttt"
.Object.Caption = "p.sub new control"
.Object.Font.Bold = True
.Object.BackColor = RGB(255, 0, 0)
End With
Any help would be appreciated.
|