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.2.Core.dll
Declaration
Property Value
| Type | Default | Description |
|---|---|---|
| Boolean | false | 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 |
|
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.