XlsxExportOptionsEx.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.v21.1.Core.dll

Declaration

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

See XlsExportOptionsEx.BandedLayoutMode to learn more.

See Also