This is a migrated thread and some comments may be shown as answers.

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

1 Answer 34 Views
This is a migrated thread and some comments may be shown as answers.
ManojKumar
Top achievements
Rank 1
ManojKumar asked on 05 Oct 2018, 12:55 PM

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

 

 

 

1 Answer, 1 is accepted

Sort by
0
Marin Bratanov
Telerik team
answered on 09 Oct 2018, 06:53 PM
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.
Tags
Grid
Asked by
ManojKumar
Top achievements
Rank 1
Answers by
Marin Bratanov
Telerik team
Share this question
or