excel

[farshad]

Hi,
Using VB.NET how is it possible to change the colour of the cells (NOT the texts in the cell) of a row or an individual cell in excel.

Thanks

 

[dynamic_sysop]

if you want to set the back color of the cells, you can use something like this...

/// where objSheet is an excel.Worksheet
objSheet.Cells(1, 1).Interior.ColorIndex = 45 /// 45 being the color ( red i think ) just mess with the values to see what colors appear.