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.v19.2.Core.dll
Declaration
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.
|
| 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.
|
| 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.
|
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.