setting the Left or Right HeaderPicture
 

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 ");
pageSetup.LeftHeaderPicture = bitmap;

neither of these seem to work.

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

Cheers

Mark

setting the Left or Right HeaderPicture
 

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

"mark_newbs" wrote in message
...
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 ");
pageSetup.LeftHeaderPicture = bitmap;

neither of these seem to work.

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

Cheers

Mark