GridXlExportOptions.SuppressMaxColumnCountError Property

Specifies whether to suppress the exception thrown when exporting more than 256 columns in an XLS file or more than 16,384 columns in an XLSX file.

Namespace: DevExpress.Blazor

Assembly: DevExpress.Blazor.v23.2.dll

NuGet Package: DevExpress.Blazor

Declaration

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

Property Value

Type	Default	Description
Boolean	false	true, to suppress the exception and export the maximum available number of columns; 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 columns exceeds the predefined limit, the grid throws an exception and cancels the export operation.

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

To suppress the maximum row count exception, use the SuppressMaxRowCountError property.