Click here to get back home

SpreadSheet::Write Excel- Is there a way to set background color for entire worksheet?

 HomeNewsGroups | Search | About
 comp.lang.perl.modules    Post an article   get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
SpreadSheet::Write Excel- Is there a way to set background color for entire worksheet? Alf McLaughlin 01-21-2005
Posted by Alf McLaughlin on January 21, 2005, 12:56 pm
Please log in for more thread options
Hello-
I have had some experience using the Spreadsheet::WriteExcel module
and have been able to set the background- or Fill- color of an
individual cell. But, I am interested in setting the default color for
the entire worksheet rather than 1 cell at a time. I have been able to
do this with for loops setting the color for each individual cell, but
this is very inefficient. I also notice there is a way to do this with
an HTML tag by creating a .xls file with the tag <BODY BGCOLOR = "color
name"> but I can't use HTML tags with the Spreadsheet::WriteExcel
module. I don't think what I want to do is possible with this module.
Does anyone know if it is possible?

Thank you,

Alf McLaughlin



Similar ThreadsPosted
How to write into existing Excel Spreadsheets? July 13, 2004, 1:24 pm
Can I write Macros in excel workbook ? October 8, 2004, 7:50 am
Create Excel chart from spreadsheet on Un*x? December 28, 2006, 11:28 pm
Spreadsheet-ParseExcel: Parsing various MS Excel file versions / grabing checkbox values? September 17, 2004, 3:11 am
starting a background process via Net::SSH::W32Perl September 7, 2004, 10:41 am
Help:Generating multiple spreadsheets in MSExcel worksheet using perl?? October 17, 2006, 11:37 am
SerialPort write question October 28, 2004, 11:52 am
Tie::YAML doesn't write to tmp file first? December 23, 2007, 9:34 am
I don't want to write an HTML templating module August 30, 2007, 5:27 am
write a new module for suffix trees? April 3, 2008, 5:12 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap