Exporting hierarchical table in excel with row grouping

Question

User-85522823 posted
I am developing one application in angular 4 where I am showing one table with hierarchical data(table inside table) it has collapse and expand toggle button. Now I want to export this pattern of data into excel and pdf format. I would like to know is there any way to export excel using interop or openxml etc.

Answer 1

User-1838255255 posted

Hi smartymca,

According to your description, as far as i know, you could use gridview to load data then nested gridview inside it, please check this tutorial:

Nested GridView with Expand Collapse example in ASP.Net using C# and VB.Net: 

https://www.aspsnippets.com/Articles/Nested-GridView-with-Expand-Collapse-example-in-ASPNet-using-C-and-VBNet.aspx 

About how to export the nested gridview to the excel, please check the following tutorials: 

How To exporting to Excel parent and nested GridView data?

https://stackoverflow.com/questions/7525537/how-to-exporting-to-excel-parent-and-nested-gridview-data 

Nested Gridview export to Excel: 

https://www.codeproject.com/Questions/276084/Nested-Gridview-export-to-Excel 

Best Regards,

Eric Du