Hi Pardeep ,
Query : Excel not export properly.
Based on your code example we found that you have customize the grouping header using Caption Template. But, when you export to Excel the customization is not applied in Group header. Currently we do not have support to apply customization when export to Excel. So, we have logged an improvement task for this “Group captioned datas exported to excel file”. This will be implemented and will be rolled out in our Volume 1, SP 1, 2020 release on or before 23rd April, 2020
You can now track the current status of your request, review the proposed resolution timeline, and contact us for any further inquiries through this link.
Till then we appreciate your patience.
Prasanna Kumar N.S.V