Export of Main and Detail or nested grids together to Excel

This example demonstrates

  • combined export of main and multiple nested grids to a single worksheet in a workbook.
  • calling of methods on details grids. In this example exportExcel method is called on the details grids.

It shows 2 ways of export:

  • Quick Export: It includes unprocessed data from detail grids without creating instance of the detail grids. It's fast.
  • Detailed Export: It includes processed data from detail grids after creating instance of all detail grids. Initial run is slow but subsequent runs are fast as the instances of detail grids are cached in memory.

Limitation: This example assumes local data of nested grids and doesn't work in case of lazy loading of nested grids.