XlsxExportOptionsEx.SuppressMaxColumnsWarning Property

Gets or sets whether to suppress the exception that is raised if you export more than 16,384 columns to an XLSX file.Only available in data-aware export mode.

Namespace: DevExpress.XtraPrinting

Assembly: DevExpress.Printing.v24.2.Core.dll

Declaration

C#

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

VB.NET

<DefaultValue(False)>
Public Property SuppressMaxColumnsWarning As Boolean

Property Value

Type	Default	Description
Boolean	false	true, to prevent the exception from raising; otherwise, false.

Remarks

The MS Excel data format imposes limitations on the total number of rows and columns in a worksheet. See the following topic to learn the exact limits:MS Excel specifications and limits.

If the SuppressMaxColumnsWarning property is false, an ArgumentOutOfRangeException exception is raised when you export the number of columns that exceeds the predefined limit.

If the SuppressMaxColumnsWarning property is true, no exception is raised. However, extra columns which exceed the predefined total column limit are not exported.