Skip to main content

XlsExportOptionsEx.BandedLayoutMode Property

Gets or sets how bands and columns are arranged in the output worksheet (when exporting from Banded Views).Only available in data-aware export mode.

Namespace: DevExpress.XtraPrinting

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

NuGet Package: DevExpress.Printing.Core

Declaration

[XtraSerializableProperty]
public BandedLayoutMode BandedLayoutMode { get; set; }

Property Value

Type Description
BandedLayoutMode

A value that identifies the current layout of bands and columns in the output worksheet.

Available values:

Name Description
Default

The layout of grid bands and columns is preserved in the output worksheet.

Grid-DataAwareExport-BandedLayoutMode-Default.png

LinearBandsAndColumns

Bands and columns are stretched out in a single line in the output worksheet. Bands are presented in the output by worksheet collapsible columns without data.

Grid-DataAwareExport-BandedLayoutMode-LinearBandsAndColumns.png

LinearColumns

Columns from all visible grid bands are stretched out in a single line in the output worksheet. Grid bands are not added to the output.

Grid-DataAwareExport-BandedLayoutMode-LinearColumns.png

Remarks

Only available in data-aware export mode.

Certain grid controls support Bands, which are used to logically and visually combine columns. For instance, see Banded Grid Views to learn abound the Banded data presentation in a WinForms Data Grid control.

The BandedLayoutMode property allows you to specify how bands and columns are arranged in the output worksheet. You can preserve the original layout of bands and columns, or transform the original layout into a plain linear view. See the description of the BandedLayoutMode enumeration to learn more.

See Also