Back to Devexpress

XlsxExportOptionsEx.SuppressMaxRowsWarning Property

corelibraries-devexpress-dot-xtraprinting-dot-xlsxexportoptionsex-677b5db7.md

latest2.2 KB
Original Source

XlsxExportOptionsEx.SuppressMaxRowsWarning Property

Gets or sets whether to suppress the exception that is raised on attempting to export more than 1,048,576 rows 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 SuppressMaxRowsWarning { get; set; }
vb
<DefaultValue(False)>
Public Property SuppressMaxRowsWarning 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 SuppressMaxRowsWarning property is false , an ArgumentOutOfRangeException exception is raised when you export the number of rows that exceeds the predefined limit.

If the SuppressMaxRowsWarning property is true , no exception is raised. However, extra rows which exceed the predefined total row limit are not exported.

See Also

SuppressMaxColumnsWarning

XlsxExportOptionsEx Class

XlsxExportOptionsEx Members

DevExpress.XtraPrinting Namespace