Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling
 
PerlMonks  

Spreadsheet::WriteExcel module

by ostra (Novice)
on Feb 08, 2014 at 18:02 UTC ( [id://1074044]=perlquestion: print w/replies, xml ) Need Help??

ostra has asked for the wisdom of the Perl Monks concerning the following question:

I am using Spreadsheet::WriteExcel module. And, I keep getting an error message called"unknown method: spreadsheet::write::format::set_big_color" excel I code for color formatting. Can somebody point out what is wrong with the code?

#! perl -w use strict; use warnings; use 5.014; use Spreadsheet::WriteExcel; my $workbook=Spreadsheet::WriteExcel->new('perl1.xls'); my $worksheet=$workbook->add_worksheet(); my $red_background=$workbook ->add_format( color => 'white', big_color => 'red', bold => 1, ); $worksheet->write(0,0,'colored cell',$red_background);

Replies are listed 'Best First'.
Re: Spreadsheet::WriteExcel module
by stefbv (Curate) on Feb 08, 2014 at 18:41 UTC
    It's 'bg_color'...

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://1074044]
Approved by stefbv
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others musing on the Monastery: (5)
As of 2024-03-29 13:44 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found