Grid excel export without child grids.

[pk]

Hi, 

how can I exclude the hierarchy grids of my main grid and export to excel the main one without those child grids?

I'm exporting with custom data, so I'm setting an ExcelExportProperties object to execute the grid.excelExport([thatObject]) and I tryied with hierarchyExportMode: "None" but its not working..

Is there any way to accomplish my request?

thanks

[Manivel Sellamuthu]

Hi pk, 

Thanks for contacting us. 

Yes. You can achieve your requirement by removing child-Grid from grid Object in beforeExcelExport event and restoring in excelExportComplete complete event of the Grid. 

Please find the below code snippet for more information. 

@{ 

    var SecondChildGrid = new Syncfusion.EJ2.Grids.Grid() 

    { 

. . . 

} 

    }; 

    var ChildGrid = new Syncfusion.EJ2.Grids.Grid() 

    { 

. . . 

}, 

        ChildGrid = SecondChildGrid 

    }; 

} 

 

    <div class="control-section"> 

        <ejs-grid id="HierarchyPrint" dataSource="ViewBag.EmpDataSource" beforeExcelExport="beforeExport" excelExportComplete="exportComplete" childGrid="ChildGrid" toolbarClick="toolbarClick" toolbar="@(new List<string>() {"ExcelExport" })" 

                  allowExcelExport="true"> 

            <e-grid-columns> 

                <e-grid-column field="EmployeeID" headerText="Employee ID" textAlign="Right" width="125"></e-grid-column> 

                <e-grid-column field="FirstName" headerText="Name" width="120"></e-grid-column> 

                <e-grid-column field="Title" headerText="Title" width="170"></e-grid-column> 

                <e-grid-column field="City" headerText="City" format='yMd' textAlign="Right" width="135"></e-grid-column> 

            </e-grid-columns> 

        </ejs-grid> 

    </div> 

 

    <script> 

        function toolbarClick(args) { 

            if (args.item.text === 'Excel Export') { 

                this.excelExport(); 

            } 

        } 

        var childGrid; 

        function exportComplete(args) { 

            this.childGrid = childGrid; 

        } 

        function beforeExport(args) { 

            childGrid = this.childGrid; 

            this.childGrid = null; 

        } 

 

    </script> 

Documentation: https://ej2.syncfusion.com/documentation/api/grid/#beforeexcelexport 

                             https://ej2.syncfusion.com/documentation/api/grid/#excelexportcomplete 

Please get back to us, if you need further assistance. 

Regards, 

Manivel 

[pk]

thanks

[Pavithra Subramaniyam]

Hi pk, 

 

Thanks for your update. 

 

Please get back to us if you need nay further assistance on this. 

 

Regards, 

Pavithra S. 

[Nitish]

Hi,

Is there any way to export it with CHILD GRID?

Thanks.

[Rajapandi Ravi]

Hi Nitish, 

 

Thanks for the update 

 

Query#: Is there any way to export it with CHILD GRID? 

 

Yes, you can export the it with Child Grid. We have already discussed about your requirement in our sample demos. Please refer the below sample demos link and screenshot for more information. 

 

Sample demos: https://ej2.syncfusion.com/aspnetcore/Grid/MasterDetailsExport#/material 

Screenshot: 

 

 

Regards, 

Rajapandi R