Add custom rows at top and bottom of while excel export

aravind167

I have a grid which i'm able t export data in excel (B)
I need to add multiple rows Static data at top & bottom row of the dymanic grid (A & C)
Which i'm not able to acheive using addrow method (its adding row in grid tbody)
I've attached screenshot of my expected excel output for reference

A & C i need to append and prepend only at the time of excel export
Is that possible to merge 3 grid (say A data in table1 , B in table2 , C in table 3 ) as a singleoutput
Please suggest how to acheive ?

Thanks in advance !!

colin

This thread here shows how to add an extended footer - the same would apply to the header.

Colin