Export multiple grid in one excel

[PDev]

I have a requirement of exporting multiple treegrid in one excel with different sheet. which is working fine. However, I can not export to excel unless i generate the control. 

e.g. I have 3 TABs on page. In each TAB I have one treegrid. If I want to export each Treegrid in different Sheet (sheet1,sheet2, sheet3) within one excel. It does not allow me unless I click on each tab and create those controls.

@ViewChild("g1") public g1: TreeGridComponent; @ViewChild("g2") public g2: TreeGridComponent;

@ViewChild('tab') public tab:TabComponent; @ViewChild("g3") public g3: TreeGridComponent;

[Manivannan Padmanaban]

Hi Parth,

Thanks for contacting Syncfusion Forums.

Query: I cannot export to excel unless i generate the control.

The Tab renders its first tab content or the selected tab content by default. When you select the other tab, its content loads dynamically. And currently, we don't have the support to render all Tab's contents on initial load. As a result, without clicking on each tab it is not possible to export the tree grid because it is not rendered.

Regards,

Manivannan Padmanaban