RadGrid Export To Excel Add Grid Lines

[Mark]

We want to add Grid Lines to exported excel. How do we do that within this event?

       protected void grdInventory_ExcelMLWorkBookCreated(object sender, Telerik.Web.UI.GridExcelBuilder.GridExcelMLWorkBookCreatedEventArgs e)
        {
            WorkBook wb = e.WorkBook;
            StyleElement header = new StyleElement("Header");
            header.FontStyle.Bold = true;
            header.FontStyle.FontName = "Arial";
            header.FontStyle.Size = 8;
            header.AlignmentElement.Attributes["ss:WrapText"] = "1";
            wb.Styles.Add(header);

 
        }

[Doncho]

Hi Mark,

Grid lines in the exported file can be applied as borders of the Grid cells. When it comes to exporting to ExcelML format, borders can be added via StyleElement in the ExcelMLExportStylesCreated event:

• https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/excel-export/excel-excelml#borders 

The same StyleElement should be passed as StyleValue to all the cells that need to be styled. This can be achieved in the ExcelMLExportRowCreated event, see:

• https://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/exporting/excel-export/excel-excelml#adding-custom-styles 

In short, here is a sample event handling that would produce Red lines separating rows and columns in the exported excel:

protected void RadGrid1_ExcelMLExportRowCreated(object sender, Telerik.Web.UI.GridExcelBuilder.GridExportExcelMLRowCreatedArgs e)
{
    foreach (CellElement cell in e.Row.Cells)
    {
        cell.StyleValue = "myCustomStyle";
    }
}

protected void RadGrid1_ExcelMLExportStylesCreated(object sender, Telerik.Web.UI.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.Red;
        borderStyle.LineStyle = LineStyle.Continuous;
        borderStyle.Weight = 1.0;
        borders.Add(borderStyle);
    }
    foreach (BorderStyles border in borders)
        cstyle.Borders.Add(border);
    e.Styles.Add(cstyle);
}

I hope this will help.

Please let me know if any questions come up.

Kind regards,
Doncho
Progress Telerik