hello,

i am following this solution it works perfectly.

Export DataTable Rows to Columns in Excel with custom columns in ASP.Net using C# and VB.Net

the only thing its missing the logic is that output should be emailid UserName  Date Shirt  type  Jeans  type Trousers type.

so after each dynamic header value i want to add custom header value type.

please advice