Radgrid excel export : <BR> to new line

[Prabeesh]

I am facing an issue with Radgrid while exporting to excel. The <BR> tag not creating a new line in the excel instead it take it as a BR text. Please help

[Kostadin]

Hi Prabeesh,

Could you specify which export method you are using? If you are using ExcelML then instead <br> tag you should use "&#10", because that is the code for the new row. The following code snippet demonstrates how you could replace the <br> tags into the excel document.

protected void RadGrid1_GridExporting(object source, GridExportingArgs e)
{
    e.ExportOutput = e.ExportOutput.Replace("<br />", "
");
}

All the best,
Kostadin
the Telerik team

[Prabeesh]

Thank You.
Above solution worked but along with the word wrap style.
Add style in ExcelMLExportStylesCreated
     Telerik.Web.UI.GridExcelBuilder.StyleElement StyleElement = new Telerik.Web.UI.GridExcelBuilder.StyleElement();
            StyleElement.Id = "brstyle";
            StyleElement.AlignmentElement.Attributes["ss:WrapText"] = "1";

and apply it for the cell in the ExcelMLExportRowCreated event

  CellElement cElement = e.Row.Cells.GetCellByName("Total Sales");
                cElement.StyleValue = "wstyle";

[Support]

If your using the Biff Excel format to avoid the Excel error on opening the Excel file, you can use this solution.  Add OnBiffExporting="grid_OnBiffExporting" client side and the method below server side.

protected void grid_OnBiffExporting( object sender, GridBiffExportingEventArgs e )
{
   foreach ( Cell cell in e.ExportStructure.Tables[ 0 ].Cells ) {
      cell.Value = cell.Text.Replace( HTML_BREAK_ROW, string.Empty );
   }
}

private const string HTML_BREAK_ROW = "<BR>";