Add custom rows at top and bottom of while excel export
Add custom rows at top and bottom of while excel export
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 !!
Answers
This thread here shows how to add an extended footer - the same would apply to the header.
Colin