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

    Specifies whether to suppress the exception thrown when exporting more than 65,536 rows in an XLS file or more than 1,048,576 rows in an XLSX file.

    Namespace: DevExpress.Blazor

    Assembly: DevExpress.Blazor.v25.1.dll

    NuGet Package: DevExpress.Blazor

    Declaration

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

    Property Value

    Type Default Description
    Boolean false

    true, to suppress the exception and export the maximum available number of rows; false, to cancel the export and throw the exception.

    Remarks

    The Microsoft Excel data formats impose the following limitations on the total number of rows and columns in a worksheet:

    File format XLS XLSX
    Total number of columns 256 16,384
    Total number of rows 65,536 1,048,576

    If the number of exported rows or columns exceeds the predefined limit, the TreeList throws an exception and cancels the export operation.

    Set the SuppressMaxRowCountError property to true to suppress the exception and export the maximum available number of rows. Extra rows are not exported.

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

    To suppress the maximum column count exception, use the SuppressMaxColumnCountError property.

    See Also