XlsExportOptions.Suppress65536RowsWarning Property

Gets or sets a value indicating whether to suppress the exception that raises when trying to export a document to an XLS file with more than 65,536 rows.

Namespace: DevExpress.XtraPrinting

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

NuGet Package: DevExpress.Printing.Core

Declaration

C#

[TypeConverter(typeof(BooleanTypeConverter))]
[XtraSerializableProperty]
public bool Suppress65536RowsWarning { get; set; }

VB.NET

<TypeConverter(GetType(BooleanTypeConverter))>
<XtraSerializableProperty>
Public Property Suppress65536RowsWarning As Boolean

Property Value

Type	Description
Boolean	true, to suppress the exception and reduce the number of rows in the resulting XLS file; false, to cancel the export and fire the exception.

Property Paths

You can access this nested property as listed below:

Object Type	Path to Suppress65536RowsWarning
ExportOptions	.Xls .Suppress65536RowsWarning

Remarks

Versions of MS Excel prior to 2007 cannot display more than 65,536 rows. If the resulting XLS file exceeds this format’s limitation, the export process depends on the Suppress65536RowsWarning option:

• If this option is set to false (the default value), the export operation is canceled and the following exception message is displayed:

  “The created XLS file is too big for the XLS format, because it contains more than 65,536 rows. Please try to use the XLSX format, instead.”

• If this option is set to true, the exception does not raise, and the document is silently exported to XLS, but only first 65,536 rows are included into the resulting file.

Note

If your document is targeted for MS Excel 2007, export it to the XLSX format (the special MS Excel 2007 format) instead. In this format, the number of rows and columns permitted has been significantly increased in comparison with XLS. For more information, refer to Export to XLSX.