in reply to Re: Problem filling Excel cells with Solid Colour: Arrays
in thread Problem filling Excel cells with Solid Colour

Thanks I did. I just did it this way to change from a hash with keys which were names to simple numbers.
  • Comment on Re^2: Problem filling Excel cells with Solid Colour: Arrays

Replies are listed 'Best First'.
Re^3: Problem filling Excel cells with Solid Colour: Arrays
by GrandFather (Saint) on Mar 03, 2021 at 20:16 UTC

    Without any further context that sounds like a really bad idea. Names convey meaning and help reduce errors.

    Optimising for fewest key strokes only makes sense transmitting to Pluto or beyond
[reply]
Re^3: Problem filling Excel cells with Solid Colour: Arrays
by merrymonk (Hermit) on Mar 03, 2021 at 16:31 UTC
    Update - I found the solution - it is in the line below where Interior can have simply Color 
    $sheet->Range($rng)->Interior      ->{Color} = $patterncolour;

    [download]
    to fill the cell.
    However it would be good to know why the solid colour definition does not work
[reply]
[d/l]

In Section Seekers of Perl Wisdom