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
[DefaultValue(false)]
public bool SuppressMaxRowCountError { get; set; }
Property Value
Type | Default | Description |
---|---|---|
Boolean | false |
|
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.