radgrid export to excel biff format

[ZR]

Hi,

I've the below format in my aspx:

 

 

<ExportSettings ExportOnlyData="true" OpenInNewWindow="true" HideStructureColumns="true">

 

 

 

<Excel Format="Biff" />

 

 

 

</ExportSettings>

 

I need to do the foll:
1) When exporting to excel, how do I left justify the header and excell cell contents .(i've biff formatting. I cannot change it to html due to excel warning message.)

I tried this in itemCommand:

GridItem

 

 

Item = (GridItem)radDASignature.MasterTableView.GetItems(GridItemType.Item)[0];

 

 

 

foreach (TableCell tcell in Item.Cells)

 

{

tcell.Text = tcell.Text.Replace(

 

"<nobr>", "");

 

tcell.Style[

 

"text-align"] = "left";

 

tcell.HorizontalAlign =

 

HorizontalAlign.Left;

 

}
This above doesn't work. Please help with code.

2) When exporting the cell content in excel,I  have <nobr> and </nobr> tags to the data. How do I get rid of them while exporting.
I set them in column created event to avoid wrapping of cell contents. However, I do not want the <nobr> added to the excel data while exporting.

[Multi]

Hi,

I had this problem and I removed the code:

boundColumn.DataFormatString = "<nobr>{0}</nobr>";


Regards,
Patrícia

[Kostadin]

Hi Zaheka,

Note that styling via CSS classes is not possible when you are using BIFF Export format. You could take a look at the following article where you can see how to styling columns/rows/cells.

All the best,
Kostadin
the Telerik team

[Dilip]

Now its working this way

protected void grdPreview_ExcelExportCellFormatting(object sender, ExcelExportCellFormattingEventArgs e)
    {
        GridDataItem item = e.Cell.Parent as GridDataItem;
        if (e.FormattedColumn.UniqueName == "Policy_Number")
        {
            e.Cell.HorizontalAlign = HorizontalAlign.Right;
        }
    }