Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

GridXlExportOptions.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.v24.2.dll

NuGet Package: DevExpress.Blazor

#Declaration

C#
[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 exceeds the predefined limit, the grid 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.

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

See Also