ASPxTreeListExportRenderBrickEventArgs.XlsxFormatString Property

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

Namespace: DevExpress.Web.ASPxTreeList

Assembly: DevExpress.Web.ASPxTreeList.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 ASPxTreeListExporter1_RenderBrick(object sender, DevExpress.Web.ASPxTreeList.ASPxTreeListExportRenderBrickEventArgs e) {
        if ( e.RowKind == DevExpress.Web.ASPxTreeList.TreeListRowKind.Data && e.TextValue != null)
        {
            double numericValue = 0;
            if (Double.TryParse(e.TextValue.ToString(), out numericValue))
            {
                e.XlsxFormatString = "0.00";
                e.TextValue = numericValue;
            }
        }
    }
...

ASPX

<dx:ASPxTreeListExporter ID="ASPxTreeListExporter1" TreeListID="ASPxTreeList1" OnRenderBrick="ASPxTreeListExporter1_RenderBrick" runat="server"></dx:ASPxTreeListExporter>
<dx:ASPxTreeList ID="ASPxTreeList1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" KeyFieldName="ProductID">
    <Columns>
        <dx:TreeListTextColumn FieldName="Id" VisibleIndex="0">
        </dx:TreeListTextColumn>
        <dx:TreeListTextColumn FieldName="Text" VisibleIndex="1">
        </dx:TreeListTextColumn>
    </Columns>
</dx:ASPxTreeList>
...

MVC approach:

Razor (View)

@Html.DevExpress().TreeList(settings => {
    settings.Name = "TreeList1";

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

    settings.SettingsExport.RenderBrick = (sender, e) => {
        if (e.RowKind == DevExpress.Web.ASPxTreeList.TreeListRowKind.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()