Exporting RadGrid to Excel questions

[Craig]

Hello,

   I have a RadGrid that displays some dollar values.  On the screen, it needs to be displayed as "$00.00 USD" but when it is exported to excel, I need the cell to be "$00.00" (no currency type).  The reason is that if I export the "USD" it is not considered a numeric column and isn't very useful.  Is there any way to modify what is placed in the excel cell on a cell by cell basis?  Is there a way to export some columns and not others?  Can I export a non-displayed column? 

Thanks for any help you can provide!!

Craig.

[Princy]

Hi,

You can set the currency format in ExportCellFormatting event as shown below.
C#:

protected void RadGrid1_ExportCellFormatting(object sender, ExportCellFormattingEventArgs e)
{
 if (e.FormattedColumn.UniqueName == "UniqueName")
 {
   e.Cell.Style["mso-number-format"] = "Currency";
 }
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
 if (e.CommandName == RadGrid.ExportToExcelCommandName)
 {
   RadGrid1.MasterTableView.GetColumn("UniqueName").Display = true;//showing the hidden columns
   RadGrid1.MasterTableView.GetColumn("UniqueName1").Display = false;//hiding the columns
 }
}

Thanks,
Princy.