Back to Devexpress

XlsxExportOptionsEx.SuppressMaxColumnsWarning Property

corelibraries-devexpress-dot-xtraprinting-dot-xlsxexportoptionsex-bbc0b346.md

latest2.3 KB
Original Source

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.v25.2.Core.dll

NuGet Package : DevExpress.Printing.Core

Declaration

csharp
[DefaultValue(false)]
public bool SuppressMaxColumnsWarning { get; set; }
vb
<DefaultValue(False)>
Public Property SuppressMaxColumnsWarning As Boolean

Property Value

TypeDefaultDescription
Booleanfalse

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.

See Also

SuppressMaxRowsWarning

XlsxExportOptionsEx Class

XlsxExportOptionsEx Members

DevExpress.XtraPrinting Namespace