in reply to Question on Excel OLE automation.

IIRC is it like: 
  $Sheet->Range('A:A')->Interior->{ColorIndex} = 27;

[download]
for columns, and 
  $Sheet->Range('1:1')->Interior->{ColorIndex} = 27;

[download]
for rows.

Regards

mwa

Replies are listed 'Best First'.
Re^2: Question on Excel OLE automation.
by Ash Rai (Acolyte) on Oct 10, 2007 at 21:33 UTC
    Sweet! This works.
    Thanks you all!
[reply]

In Section Seekers of Perl Wisdom