excel cell coloring

c# colors cell
bill picture bill · May 5, 2011 · Viewed 55.1k times · Source

I am using c# to color particular cells of excel file. I am using:

Application excel = new Application();
Workbook wb = excel.Workbooks.Open(destPath);
 Worksheet ws = wb.Worksheets[1];
 ws.get_Range(ws.Cells[row, clmn]).Cells.Interior.Color = 36;

...to color cells, but this is not working. Can anyone help me out?

Answer

Stecya picture Stecya · May 5, 2011

Try something like that

ws.Cells[row, clmn].Interior.Color = System.Drawing.ColorTranslator.ToOle(System.Drawing.Color.Red)

Related questions

c# excel how to change a color of a particular row

I want to ask you guys, how to change color of a row to red in Excel table if the cell 1 isn't null. XX YY ZZ ----------------- aa bb cc aa1 bb1 cc1 aa2 cc2 aa3 bb3 cc3 aa4 Excel.…

Read More
How do I get the color from a hexadecimal color code using .NET?

How can I get a color from a hexadecimal color code (e.g. #FFDFD991)? I am reading a file and am getting a hexadecimal color code. I need to create the corresponding System.Windows.Media.Color instance for the hexadecimal …

Read More
Set System.Drawing.Color values

Hi how to set R G B values in System.Drawing.Color.G ? which is like System.Drawing.Color.G=255; is not allowed because its read only Property or indexer 'System.Drawing.Color.G' cannot be assigned toit is read …

Read More