RADGrid Export to Excel Wrap Text format

[James]

I have an export to excel where I enter 
 the excel crlf character. All of that works fine but when I open the excel file the column is not formatted to handle crlf and I have to set it to Wrap Text manually. Is there any way to format this column with wrap text?

 

Thanks,

James

[Pavlina]

Hello,

To wrap the text of the desired cell you should find the respective cell, set its TextWrap property by hooking OnInfrastructureExporting exporting event and insert the newline character ('\n') wherever you want the text to be wrapped. A sample code which presents header cell text wrapping is attached below:

protected void rgProfile_InfrastructureExporting(object sender, GridInfrastructureExportingEventArgs e)
    {
        Telerik.Web.UI.ExportInfrastructure.Table tbl = e.ExportStructure.Tables[0];

        var cell1 = tbl.Cells[2, 1];
        cell1.Value = "First line .\nSecond line";
        cell1.TextWrap = true;

    }

Regards,
Pavlina
Telerik by Progress

[James]

That worked perfectly. I then set my column width and every row in the column to wrap

 

       Telerik.Web.UI.ExportInfrastructure.Table tbl = e.ExportStructure.Tables[0];
        tbl.Columns[2].Width = 225;
        for (int i = 1; i <= tbl.Rows.Count; i++)
        {
            var cell1 = tbl.Cells[2, i];
            cell1.TextWrap = true;
        }