Excel - print titles on bottom of page using c#.

May 10 2010 7:07 AM

Hello,
This is an excel question as well as c#.
Using c# on VS2008, i am producing an excel document. I am trying to get a title block as a footer to behave similar to excels 'print titles' (print titles on bottom of page rather than on the top). The footer title is a table (or group of cells), so cannot be simply added as footer text. If i was to add the title as cells on the bottom of each worksheet (not as a footer note), then when i insert rows the bottom title will move onto the next page, which is unsuitable.
I have googled quite a bit and have not found any answer to this. Any ideas please.
Thanks
Arfan