[Solved] Newline problem in a cell of excel

[Minkyu Lee]

Hello,

Column A	Column                B

 

protected void RadGrid1_ExcelMLExportRowCreated(object source, GridExportExcelMLRowCreatedArgs e)
    {
        if (e.RowType == GridExportExcelMLRowType.HeaderRow)
        {
            for (int i = 0; i < e.Row.Cells.Count; i++)
            {
                e.Row.Cells[i].Data.DataItem = e.Row.Cells[i].Data.DataItem.ToString().Replace("<br />", "\r\n");
            }
        }
    }

The above grid has 2 columns which are 'Column<br />A' and 'Column<br />B'.

When I export data using excelml, I replace '<br />' with '\r\n'. However it is not working.

How can I insert new line?

Thank you.

Minkyu Lee.

[Shinu]

Hello,


Try adding table structure in HeaderTemplate to get the appearance (instead of adding br) and see whether it helps.


-Shinu.