[WINFORM] Grid to excel export with user defined cell formatting (cell color)

Question

Hi Everyone Already i have done grid to excel export but now i need to change the cell backcolor or cell color with user defined values.did anyone pass through this. Please share the code guys or your ideas Cheers Narasimman

narasimman g · Answer

Hi suthish thanks for the post Already i have done the cell text color using below property. xlWorkSheet.Application.ActiveCell.Font.ColorIndex = 30; but ur code snippet is pure and clean I need to change the cell background color:( stickin with it!! any helppppp cheers

Suthish Nair · Answer

http://msdn.microsoft.com/en-us/library/4zs9xy29(v=vs.80).aspx

narasimman g · Answer

Hi Suthish Already i have done with excel creation!!! need to format the cells !!!! please look my exisiting thread for excel creation http://www.c-sharpcorner.com/Forums/ShowMessages.aspx?ThreadID=103625

Suthish Nair · Answer

you need to use excel interops.