To get started, create a new spreadsheet application with the help of the DevExpress Template Gallery
.
-
Start a new project in Visual Studio, select DevExpress Template Gallery, and launch Project Wizard. Select required options for a Winforms Ribbon Form Spreadsheet application and click Create.

The application will be created automatically.
- When a new application is ready, click the SpreadsheetControl smart tag in the Visual Studio designer and select Create Mail Merge Bars to add a Mail Merge tab.
- Select Create Field List Panel to add the Field List Panel panel to the right of the SpreadsheetControl.
- Select Create Parameters Panel to add the Parameters Panel to the bottom right of the SpreadsheetControl.
- Run the application.
- Select the "B3:I13" cell range and click the Detail button on the Mail Merge tab, in the Template Ranges group. This cell range will be repeated for each record of the data source.
- Click Select Data Member to invoke a dialog to select Suppliers as the data member in the worksheet data source.
- Specify a header to display above all detail range instances in the resulting worksheet. Select the "B3:I3" range. Click the Header button on the Mail Merge tab.
- Add a nested level to the detail range to display the detail-level data from the SuppliersProducts child table. Select the "B9:I13" cell range, click the Master-Detail button, and then click Detail Level in the invoked submenu. The DetailLevel0 range will be created.
- Select Master-Detail->Data Member to specify SuppliersProducts nested data member for the Detail Level 0.
- Select the "D13:I13" cell range for the next level sub-detail area (Detail Level 1) and click Master-Detail->Detail Level to mark it up.
- Select Master-Detail->Data Member to specify ProductsOrder Details nested data member for the DetailLevel1.
The resulting template is shown below:
