Jump to content
Xtreme .Net Talk

Recommended Posts

Posted

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

Farshad
  • Leaders
Posted

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.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...