radGrid Excel Export Issue

[Justin]

I'm having issues with two things, anyone know how to fix these?

My headers are links because they are sortable in the grid. How do you make it so they aren't links in Excel? Also when I add the image it overlaps the data exported, it there a way to push the data down?

Thanks! 

[Shinu]

Hello Justin,

Try the following code.
C#:

protected void RadGrid1_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)
{
 if (e.FormattedColumn.UniqueName == "UniqueName")
 {
   TableCell cell = item["UniqueName"];
   cell.Text = cell.Text;
 }
}

-Shinu.

[Daniel]

Hi Justin,

Another option would be to set ExportOnlyData to true (in ExportSettings)

Regards,
Daniel
the Telerik team