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!
|
|---|
| 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 |