Excel and C#

[Rick]

Hi guys!
im building an excel workshet with this sample
http://www.c-sharpcorner.com/Code/2004/March/ExcelReportsInNet.asp

but now im trying to add a background (color) to the rows but i dont know
how to do it, any idea??

Regards.
Rick

 

[newscorrespondent]

I am not familiar with that example but this is how I do it.

Record a macro to get the color index you want.

ExcelRange = YouthCenterSurveySheet.get_Range
(MyExcel.GetCellReference(CurrentLine, TotalColumn),
MyExcel.GetCellReference(CurrentLine, Member_Column));
ExcelRange.Select();
ExcelRange.Interior.ColorIndex = 8;
ExcelRange.Interior.Pattern = (int) Excel.Constants.xlSolid;
ExcelRange.Interior.PatternColorIndex = (int) Excel.Constants.xlAutomatic;

 

[Rick]

Thanks a lot!!!

It works perfect!!!

Regards.
Ricardo