in reply to Changing the background color of an excel cell

Add the following:

$Sheet->Cells(22,31)->{Interior}->{ColorIndex} = 6;

Update: it should also be possible to do:

$Sheet->Cells(22,31)->{Interior}->{Color} = $Excel->RGB(255,255,0);

Update 2: you can pack the RGB values manually and this seems to work:

$Sheet->Cells(1,1)->{Interior}->{Color} = ($blue << 16) + ($green << 8) + $red;

Hope this helps!


s^^unp(;75N=&9I<V@`ack(u,^;s|\(.+\`|"$`$'\"$&\"\)"|ee;/m.+h/&&print$&

Replies are listed 'Best First'.
Re: Changing the background color of an excel cell
by Crazy me (Initiate) on Jun 26, 2014 at 10:00 UTC
    This is one of easiest things to do  $Sheet->Range("A4:A8")->{Interior}->{Color} = 255;