Re^2: Problem filling Excel cells with Solid Colour: Arrays


We don't bite newbies here... much
	PerlMonks

by merrymonk (Hermit)

on Mar 03, 2021 at 11:04 UTC ( [id://11129076]=note: print w/replies, xml )

Need Help??

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]

Domain Nodelet^?

Node Status^?

node history
Node Type: note [id://11129076]
help

Chatterbox^?

How do I use this? • Last hour • Other CB clients

Other Users^?

Others perusing the Monastery: (5)

As of 2024-04-23 22:43 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

No recent polls found