Radgrid Export to excel with custom rows above radgrid data

2 posts, 0 answers
  1. Jatin
    Jatin avatar
    2 posts
    Member since:
    Aug 2016

    Posted 02 Aug 2016 Link to this post

    Dear Team,

    I am using below function to export to grid to Excel.


    But i have to customize the exported excel file with some text box values and drop down values above rad grid data. Please find attached required exported excel file for more clarification.

    Kindly let me know how this can be achieved.

    Thank you.



  2. Viktor Tachev
    Viktor Tachev avatar
    2497 posts

    Posted 04 Aug 2016 Link to this post

    Hi Jatin,

    You can add custom information to the exported file. The specific approach would depend on the Excel format that you are using for export.

    If you are using HTML format you can handle the HTMLExporting event of RadGrid and customize the generated code based on your requirements.

    In case you are using BIFF export you should handle the 
    BiffExporting event. For the rows above the grid you should add new rows above the exported data and define their contents. Take a look at the article below for additional information:

    Viktor Tachev
    Telerik by Progress
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Back to Top