Question on Excel OLE automation.

Ash Rai has asked for the wisdom of the Perl Monks concerning the following question:

Hello monks!

My requirement is to set color for a whole row in excel sheet. I found the following statement for coloring cells:
$Sheet->Range('A1')->Interior->{ColorIndex} =27;
I tried modifying it to:
$Sheet->Range('1')->Interior->{ColorIndex} =27;
I also tried
$Sheet->Rows('1')->Interior->{ColorIndex} =27;
All of it to no avail, does anyone know what property can I use? Thanks you monks.

Comment on Question on Excel OLE automation. Select or Download Code

Replies are listed 'Best First'.
Re: Question on Excel OLE automation. by mwah (Hermit) on Oct 10, 2007 at 21:23 UTC
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	[reply] [d/l] [select]
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]
Re: Question on Excel OLE automation. by ikegami (Patriarch) on Oct 10, 2007 at 21:03 UTC
Have you checked the docs? Specifically, How to: Refer to Rows and Columns. Drop the quotes from your last version. `$Sheet->Rows(1)->Interior->{ColorIndex} =27;`	[reply] [d/l]