setting the Left or Right HeaderPicture

[Guest]

Hi,
I am working in c# and I am trying to set the HeaderImage of a worksheet. I
have tried several methods:

Excel.PageSetup pageSetup = (Excel.PageSetup)xlSheet.PageSetup;
pageSetup.LeftHeaderPicture.Filename = @"C:\image.gif";

as well as:

Bitmap bitmap = new Bitmap(@"C:\image.gif");
pageSetup.LeftHeaderPicture = bitmap;

neither of these seem to work.

There is very little documentation on this feature, can anyone help?

Cheers

Mark

 

[NickHK]

Marks,
According to the VBA Help:
<Quote>
With ActiveSheet.PageSetup.LeftHeaderPicture
.FileName = "C:\Sample.jpg"
......... etc

' Enable the image to show up in the left header.
ActiveSheet.PageSetup.LeftHeader = "&G"

End Sub
Note It is required that "&G" is a part of the LeftHeader property string
in order for the image to show up in the left header.

</Quote>

NickHK