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