Format column in export Excel from radgrid.

[aks]

I am exporting a radgrid to Excel.  The columns are exporting, but the data is formatted incorrectly.  I am using OnExcelMLExportStylesCreated.  I would like to format a number column to include commas in the number (ex. 1,000) but with no decimals.  What am I doing wrong?  I've tried every number format type.

Also, how do I format a date field to be MM/dd?

Thanks in advance.

protected void grdOpenItemsByJurisdiction_ExcelMLExportStylesCreated(object source, GridExportExcelMLStyleCreatedArgs e)
        {
            StyleElement myStyle = new StyleElement("myCustomStyle");

            myStyle.NumberFormat.FormatType =  NumberFormatType.GeneralNumber;
            myStyle.NumberFormat.Attributes["ss:Format"] = "0";
            myStyle.FontStyle.Bold = true;
            e.Styles.Add(myStyle);
        }

protected void grdWorkItemsJurisdiction_ExcelMLExportRowCreated(object source, GridExportExcelMLRowCreatedArgs e)
        {

            e.Row.Cells.GetCellByName("TotalItems").StyleValue = "myCustomStyle";

        }

[aks]

Bump..

[Shinu]

Hello,

You can style columns in ExcelExportCellFormatting  event. Check the following help documentation which explains more about this.
Word/Excel export (HTML-based).

-Shinu.

[khalid]

can you please give me full code for HTML based formating to Export. I have seen few lines of code but i need full export code. As some of my columns are populating online side means when open into browser then i can fill some columns.

thanks

[Eyup]

Hello Khalid,

You can find an actual live sample here:
http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/exporting/excel-export/defaultcs.aspx

Do you mean that you are creating the columns programmatically?
http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/defining-structure/creating-a-radgrid-programmatically

Hope this helps. If you have different requirements or further instructions, please elaborate on your specific scenario and send us sample screenshots or video demonstrating the desired behavior.

Regards,
Eyup
Telerik