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?
Enable the default footer of the grid (ShowFooter = true) and inject the text in it wiring the ItemDataBound server event (when e.Item is GridFooterItem). The footer should be included in the exported file as it is part of the control.
The other method to insert footer text on PreRender is to locate the footer using the GetItems method from the server API (see more on it here).