Radgrid Export to excel with custom rows above radgrid data

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

    Posted 02 Aug Link to this post

    Dear Team,

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

      RadGrid1.MasterTableView.ExportToExcel();

    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
    Admin
    Viktor Tachev avatar
    1488 posts

    Posted 04 Aug 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:



    Regards,
    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.
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top