TreeListXlExportOptions.SuppressMaxColumnCountError Property
Specifies whether to suppress the exception thrown when exporting more than 256 columns to an XLS file or more than 16,384 columns to an XLSX file.
Namespace: DevExpress.Blazor
Assembly: DevExpress.Blazor.v24.2.dll
NuGet Package: DevExpress.Blazor
Declaration
[DefaultValue(false)]
public bool SuppressMaxColumnCountError { get; set; }
Property Value
Type | Default | Description |
---|---|---|
Boolean | false |
|
Remarks
The Microsoft Excel data formats impose the following limitations on the total number of rows and columns in a worksheet:
File format | XLS | XLSX |
---|---|---|
Total number of columns | 256 | 16,384 |
Total number of rows | 65,536 | 1,048,576 |
If the number of exported rows or columns exceeds the predefined limit, the TreeList throws an exception and cancels the export operation.
Set the SuppressMaxColumnCountError
property to true
to suppress the exception and export the maximum available number of columns. Extra columns are not exported.
async Task ExportXlsx_Click() {
await MyTreeList.ExportToXlsxAsync("ExportResult", new TreeListXlExportOptions() {
SuppressMaxColumnCountError = true
});
}
To suppress the maximum row count exception, use the SuppressMaxRowCountError property.