Hi team,
I am using Infragistics version 9.1.28 and will update in upcoming month but this is requirement i have to deliver.Requirement: Using Hierarchical Grid load on demand feature. We need to export Data to excel with both parent and child grid data. But we have 2 separate API's to call Parent Row Data and Child Row Data. Also by default i want to expand first parent-child row.Please provide a solution how to achieve the above mentioned.
Data Format:
Parent Data API:
Please reply ASAP.
Hello Shobhana,
Since we have recently worked on a few cases together, you are most likely familiar that according to our support policy, version 9.x is long expired and no longer eligible for support services. Thus, we can provide samples and resources against supported versions only. Thank you for understanding.
The built-into the grid Excel export along with remote data operations is a special case and would not function in the same way as a regular grid containing all the data. As stated in the “Export All Data” section of the Export to Excel documentation topic,
"There are some cases when you might be using remote operations like Paging and the Grid won't have access to all of its data. In these cases, we recommend using the Excel Export Service and pass the whole data collection, if available. Example:"
public exportButtonHandler() { this.excelExportService.exportData(this.localData, new IgxExcelExporterOptions('ExportedDataFile')); }
More about the Excel Exporter service can be found here.
This means that if you would like to have load on demand and excel export for both parent and child levels, you will have to make an API call that receives all the data at the point of exporting.
Please, keep in mind that how this call constructs the data and its model is an application-level concern and is not related to the Ignite UI for Angular controls.
To address your question about expanding the first row, the expandRow method could be used. It was available in the earlier version 9.1.28 as well.
Best regards, Bozhidara Pachilova Associate Software Developer
Thank u for replying. Appreciate. the solution works.
Hi Shobhana,
I am glad that you find my suggestion helpful. Thank you for using Infragistics components!
Best regards, Bozhidara Pachilova
Please reply