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


Comment on Re: Spreadsheet::WriteExcel setting color in drop-down box
Select or Download Code

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (10)
As of 2014-08-01 14:19 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    Who would be the most fun to work for?















    Results (23 votes), past polls