Skip to main content

XlsExportOptions.Suppress256ColumnsWarning 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 256 columns.

Namespace: DevExpress.XtraPrinting

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

NuGet Package: DevExpress.Printing.Core


public bool Suppress256ColumnsWarning { get; set; }

Property Value

Type Description

true, to suppress the exception and reduce the number of columns 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 Suppress256ColumnsWarning
.Xls .Suppress256ColumnsWarning


Versions of MS Excel prior to 2007 cannot display more than 256 columns. If the resulting XLS file exceeds this format’s limitation, the export process depends on the Suppress256ColumnsWarning 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 256 columns. 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 256 columns are included into the resulting file.


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.

See Also