ExceL ML not working

[AG]

I am trying to generate Excel ML Export file but no cell is getting created. It is generating file with empty rows. Any ideas ?

[Daniel]

Hello AG,

Judging by the provided information, you have to set UseAllDataFields to true as explained in our documentation:
ExcelML basics

Kind regards,
Daniel
the Telerik team

[AG]

Thanks, it worked ! Another question , how to set decimal places in excel  and gridlines around it.



Regards,

[Daniel]

Hello AG,

Question 1: How to set decimal places:

Create your own style on ExcelMLExportStylesCreated

protected void RadGrid1_ExcelMLExportStylesCreated(object source, GridExportExcelMLStyleCreatedArgs e)
{
    StyleElement myStyle = new StyleElement("myCustomStyle");
    myStyle.NumberFormat.FormatType = NumberFormatType.Currency;  //Option 1: Predefined number format
    //   myStyle.NumberFormat.Attributes["ss:Format"] = "MM/dd";  // Option 2: Custom format
    myStyle.FontStyle.Bold = true;
    e.Styles.Add(myStyle);
}

Assign this style to the desired cells on ExcelMLExportRowCreated :

protected void RadGrid1_ExcelMLExportRowCreated(object source, GridExportExcelMLRowCreatedArgs e)
{
    e.Row.Cells.GetCellByName("Name").StyleValue = "myCustomStyle";
}

For more information please examine the following link:
ExcelML basics

Question 2: How to set gridlines:

protected void RadGrid1_ExcelMLExportStylesCreated(object source, GridExcelBuilder.GridExportExcelMLStyleCreatedArgs e)
{
    StyleElement cstyle = new StyleElement("MyCustomStyle");
    BorderStylesCollection borders = new BorderStylesCollection();
    BorderStyles borderStyle;
    for (int i = 1; i <= 4; i++) //four borders
    {
        borderStyle = new BorderStyles();
        borderStyle.PositionType = (PositionType)i;
        borderStyle.Color = System.Drawing.Color.Black;
        borderStyle.LineStyle = LineStyle.Continuous;
        borderStyle.Weight = 1.0;
        borders.Add(borderStyle);
    }
    foreach (BorderStyles border in borders)
        cstyle.Borders.Add(border);
    e.Styles.Add(cstyle);
}

Regards,
Daniel
the Telerik team