views:

20

answers:

0

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.