Telerik RadGrid adding footer row

Question

I have a Telerik RadGdir that loads data dynamically using OnNeedDataSource. Once all the data is bound, I want to use the PreRender event to add a footer row that will contain text that describes the grid data. This grid then gets exported to Excel. The requirement is, I need to get the footer data into Excel.......

1) How do I add a footer row to a RadGrid with the specific text?

alternate solution....

2) How can I add the footer row with the specific text when performing the Excel Export?

Answer 1

I found an answer here on TelerikSupport - RadGrid footers forum