ASPxGridViewExportRenderingEventArgs.XlsxFormatString Property

Specifies the format string applied to the processed brick’s value when exporting to Excel format (XLS or XLSX).

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v23.2.dll

NuGet Package: DevExpress.Web

Declaration

C#

public string XlsxFormatString { get; set; }

VB.NET

Public Property XlsxFormatString As String

Property Value

Type	Description
String	A String value.

Remarks

Use the XlsxFormatString property to specify an Excel format string which is applied to the brick’s value when exporting to XLS or XLSX.

Example

The following example illustrates how to use the XlsxFormatString property.

Web Forms approach:

C#

protected void Exporter2_RenderBrick(object sender, DevExpress.Web.ASPxGridViewExportRenderingEventArgs e) {
    if (e.RowType == GridViewRowType.Data && e.TextValue != null) {
        double numericValue = 0;
        if (Double.TryParse(e.TextValue.ToString(), out numericValue)) {
            e.XlsxFormatString = "0.00";
            e.TextValue = numericValue;
        }
    }
}
...

ASPX

<dx:ASPxGridView runat="server" ID="Grid1" KeyFieldName="ID">
    ...   
    <Columns>
        <dx:GridViewDataTextColumn FieldName="ID"></dx:GridViewDataTextColumn>
        <dx:GridViewDataTextColumn FieldName="Text"></dx:GridViewDataTextColumn>
    </Columns>
</dx:ASPxGridView>
<dx:ASPxGridViewExporter runat="server" ID="Exporter1" GridViewID="Grid1" OnRenderBrick="Exporter1_RenderBrick">
</dx:ASPxGridViewExporter>
...

MVC approach:

Razor (View)

@Html.DevExpress().GridView(settings => {
    settings.Name = "Grid1";

    settings.Columns.Add("ID");
    settings.Columns.Add("Text");

    settings.SettingsExport.RenderBrick = (sender, e) => {
        if (e.RowType == GridViewRowType.Data && e.TextValue != null) {
            double numericValue = 0;
            if (Double.TryParse(e.TextValue.ToString(), out numericValue)) {
                e.XlsxFormatString = "0.00";
                e.TextValue = numericValue;
            }
        }
    };
}).Bind(Model).GetHtml()