Radgrid - Export to Excel - HTML - Group Column - Add Border

2 posts, 0 answers
  1. ManojKumar
    ManojKumar avatar
    1 posts
    Member since:
    Jun 2017

    Posted 05 Oct 2018 Link to this post

    Hi

    I am a trying to export radgrid to excel.

    My Export settings are as follows

    <ExportSettings FileName="Reports" ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true" Excel-Format="Html"></ExportSettings>

    I am setting border below in 

    protected void RadGrid1_HTMLExporting(object sender, GridHTMLExportingEventArgs e)
    {
                e.Styles.Append("th { border:solid 0.1pt #CCCCCC; }");

    }

     

    I am able to export with border. But my Group Column was separated as 2 cell in output. 

    I have attached 2 images (expected results vs error_output)

    Please help!!!

     

     

     

  2. Marin Bratanov
    Admin
    Marin Bratanov avatar
    4494 posts

    Posted 09 Oct 2018 Link to this post

    Hello,

    It is likely that the blank row below the headers is the filter row and the following article shows how to hide it when exporting: https://www.telerik.com/support/kb/aspnet-ajax/grid/details/how-to-remove-the-filter-row-from-excel-export.


    Regards,
    Marin Bratanov
    Progress Telerik
    Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Back to Top