Can anybody help me on this?
I have a gridview populated,When I export the gridview content to excel I want some of the cells to be merged and formatted.Supposing,if my gridview is populated with the content as below,
NAME DATE UPDATE DESCRIPTION xxx 4/10/2010 aaa aaa xxx 4/10/2010 bbb bbb yyy 4/10/2010 ccc ccc
I want to be formatted one like below when it is exported to excel,
NAME DATE UPDATE DESCRIPTION aaa aaa xxx 4/10/2010 bbb bbb yyy 4/10/2010 ccc ccc
Where the Name and Date which are repeated occurs only once(merged) as single row for all 'update' and 'description' column on the particular date and for a particular person.