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

[ManojKumar]

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!!!

 

 

 

[Marin Bratanov]

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