Images in Footer

[Roderick Prince]

Is it possible to insert an image into the footer of a sheet?

In my case I have a template that has an image in the right section of the footer. I need to dynamically set the left footer. Upon opening the results file the right footer is gone.

So, I am assuming I have to now dynamically set the right footer.

Note: if I don''t dynamically set the left footer the right footer does not get lost in the results file.

[Roderick Prince]

Additionally, how does one modify the font attributes of footer elements - those from the template are lost after dynamically setting the LeftFooter value.

[Administrator]

Hi Roderick,

1) The image being lost is a bug, I have filed a bug report with the development team. It should be addressed shortly, you can track the live status of this issue here,

http://www.syncfusion.com/support/issues/excelrw/Default.aspx?ToDo=view&questId=247

Also, there is no API support for inserting images into footers so they only way is to set the footer in template spreadsheet. I will also log this as a feature with the development team[#161].

2) The string that the header/footer takes is a script that you can use to format the header. Please refer to this documentation for more information on formatting the string

http://support.microsoft.com/?kbid=213618

Example,

mySheet.PageSetup.CenterHeader = @"&""Gothic,bold""Center Header Text";

Please let me know if you have any questions.

Thanks,

Stephen.