How to: Export a Specific Detail View

• Feb 25, 2022

Do the following to export a specific detail View (without a master row):

1. Access a detail View (see Patterns and Clones).
2. Maximize (zoom) this detail View with the BaseView.ZoomView method, or the Zoom Button.
3. Export the detail View. For instance, use the BaseView.ExportToXlsx method.
4. Restore the initial layout using the detail View’s NormalView method.

C#

using DevExpress.XtraGrid.Views.Grid;
using DevExpress.Utils;
using DevExpress.XtraGrid.Views.Base;

GridView masterView = gridView1;
masterView.OptionsDetail.DetailMode = DetailMode.Classic;

int rowHandle = 3;
masterView.ExpandMasterRow(rowHandle);
ColumnView detailView = gridView1.GetDetailView(rowHandle, 0) as ColumnView;
detailView.ZoomView();
detailView.ExportToXlsx("c:\\Temp\\export.xlsx");
detailView.NormalView();

VB.NET

Imports DevExpress.XtraGrid.Views.Grid
Imports DevExpress.Utils
Imports DevExpress.XtraGrid.Views.Base

Dim masterView As GridView = gridView1
masterView.OptionsDetail.DetailMode = DetailMode.Classic

Dim rowHandle As Integer = 3
masterView.ExpandMasterRow(rowHandle)
Dim detailView As ColumnView = TryCast(gridView1.GetDetailView(rowHandle, 0), ColumnView)
detailView.ZoomView()
detailView.ExportToXlsx("c:\Temp\export.xlsx")
detailView.NormalView()