Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: Spreadsheet::WriteExcel setting color in drop-down box

by imrags (Monk)
on Jul 17, 2009 at 10:42 UTC ( #781015=note: print w/replies, xml ) Need Help??


in reply to Spreadsheet::WriteExcel setting color in drop-down box

If you are on Windows box, i'd highly recommend using Win32::OLE...
Here's a very good link: Tek-Tips
For WriteExcel formatting:
You need to first add the format:
$footer = $excel->add_format(); $footer->set_font('Verdana'); $footer +->set_color('Blue'); $footer->set_size(9); $footer->set_bold(); $footer->set_top(); $fo +oter->set_left(); $footer->set_right(); $footer->set_bottom();
Something similar to the above.
Define this when the condition becomes true and then
$sheet->write($srow,$scol,'=FORMULA',$footer);
Raghu

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://781015]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others studying the Monastery: (7)
As of 2017-11-24 16:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In order to be able to say "I know Perl", you must have:













    Results (351 votes). Check out past polls.

    Notices?