Skip to main content
All docs
V25.1
  • TreeListXlExportOptions.SuppressEmptyStrings Property

    Specifies whether the TreeList export empty strings as blank cells in Excel formats.

    Namespace: DevExpress.Blazor

    Assembly: DevExpress.Blazor.v25.1.dll

    NuGet Package: DevExpress.Blazor

    Declaration

    [DefaultValue(false)]
    public bool SuppressEmptyStrings { get; set; }

    Property Value

    Type Default Description
    Boolean false

    true to export empty strings as blank cells; false to export empty strings as empty string values.

    Remarks

    In XLS and XLSX file formats, empty cell values can be displayed as empty strings or as blank (null) cells.

    The TreeList exports empty strings as non blank values. The Microsoft Excel ISBLANK function returns false for such cells. Set the SuppressEmptyStrings property to true to export empty strings as null values. In this case, the ISBLANK function for these cells returns true.

    async Task ExportXlsx_Click() {
        await MyTreeList.ExportToXlsxAsync("ExportResult", new TreeListXlExportOptions() {
            SuppressEmptyStrings = true
        });
    }
    
    See Also