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
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;
    to fill the cell.
    However it would be good to know why the solid colour definition does not work