I need sample code to set title and row formatting while export data from datagridview in c#.

I want to add header to excel sheet ,while exporting datagridview data to excel.

The format should be as follows

                             CUSTOMER LEDGER REPORT

Name  Debit Credit

abc     1200    0

xyz                600

Total   600      0     

I want to do this same in c#, last row should be highlighted, header should be bold