Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Re: Unable to Write Spreadsheet Text in Color

by choroba (Archbishop)
on Mar 13, 2020 at 01:22 UTC ( #11114198=note: print w/replies, xml ) Need Help??

in reply to Unable to Write Spreadsheet Text in Color

It's just a mistake in the documentation. Use set_color instead.

Also, you need to specify the format as the third argument to write in order to use it:

$format->set_color( 'red' ); $worksheet->write( 'A1', 'test', $format );

map{substr$_->[0],$_->[1]||0,1}[\*||{},3],[[]],[ref qr-1,-,-1],[{}],[sub{}^*ARGV,3]

Replies are listed 'Best First'.
Re^2: Unable to Write Spreadsheet Text in Color
by roho (Chancellor) on Mar 13, 2020 at 01:39 UTC
    Thanks choroba. That was it. And you're right about the format; it was an oversight in my sample code.

    "It's not how hard you work, it's how much you get done."

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://11114198]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (3)
As of 2020-06-04 04:16 GMT
Find Nodes?
    Voting Booth?
    Do you really want to know if there is extraterrestrial life?

    Results (30 votes). Check out past polls.