Style Exported XLSX and PDF Documents

If you need to style the exported RadGridView differently from its default style when exporting using the ExportToXlsx & ExportToPdf methods, you can use the ElementExportingToDocument event and through the GridViewElementExportingToDocumentEventArgs set the VisualParameters property to a new instance of the CellSelectionStyle class.

The class provides the following useful properties:

• CellBorders: Gets or sets the borders of the cells.
• Fill: Gets or sets the fill of the cells.
• FontFamily: Gets or sets the font family of the text of the cells.
• FontSize: Gets or sets the font size of the text.
• ForeColor: Gets or sets the foreground of the text of the cells.
• Format: Gets or sets the format of the text.
• HorizontalAlignment: Gets or sets the horizontal alignment.
• Indent: Gets or sets the intent of the cells.
• IsBold: Gets or sets the IsBold property of the cells.
• IsItalic: Gets or sets the isItalic property of the cells.
• IsLocked: Gets or sets the isLocked property of the cells.
• IsWrapped: Gets or sets the IsWrapped property of the cells.
• StyleName: Gets or sets the StyleName property of the cells.
• Underline: Gets or sets the Underline of the text in the cells.
• VerticalAlignment: Gets or sets the vertical alignment.

Example 1: Style exported XLSX/PDF document

• C#
• VB.NET

private void ElementExportingToDocument(object sender, GridViewElementExportingToDocumentEventArgs e) 
{ 
    if (e.Element == ExportElement.HeaderRow) 
    { 
        (e.VisualParameters as GridViewDocumentVisualExportParameters).Style = new CellSelectionStyle() 
        { 
            FontSize = 20, 
            IsBold = true, 
            Fill = new PatternFill(PatternType.Solid, Colors.Blue, Colors.Blue), 
            ForeColor = new ThemableColor(Colors.White) 
        }; 
    } 
    else if (e.Element == ExportElement.Row) 
    { 
        (e.VisualParameters as GridViewDocumentVisualExportParameters).Style = new CellSelectionStyle() 
        { 
            Fill = new PatternFill(PatternType.Solid, Colors.White, Colors.White), 
            ForeColor = new ThemableColor(Colors.Black) 
        }; 
    } 
} 

Private Sub ElementExportingToDocument(ByVal sender As Object, ByVal e As GridViewElementExportingToDocumentEventArgs) 
    If e.Element = ExportElement.HeaderRow Then 
        TryCast(e.VisualParameters, GridViewDocumentVisualExportParameters).Style = New CellSelectionStyle() With { 
            .FontSize = 20, 
            .IsBold = True, 
            .Fill = New PatternFill(PatternType.Solid, Colors.Blue, Colors.Blue), 
            .ForeColor = New ThemableColor(Colors.White) 
        } 
    ElseIf e.Element = ExportElement.Row Then 
        TryCast(e.VisualParameters, GridViewDocumentVisualExportParameters).Style = New CellSelectionStyle() With { 
            .Fill = New PatternFill(PatternType.Solid, Colors.White, Colors.White), 
            .ForeColor = New ThemableColor(Colors.Black) 
        } 
    End If 
End Sub