Check out this link. http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel/lib/Spreadsheet/Wri teExcel.pm#set_custom_color(%24index%2C_%24red%2C_%24green%2C_%24blue
It explains the FORMAT METHODS that come w/ the Spreadsheet::WriteExcel module. Hope this helps. Brian Volk PS: forgive the top-post' following suit. :~) -----Original Message----- From: Brian Bernard [mailto:[EMAIL PROTECTED] Sent: Thursday, December 22, 2005 7:08 AM To: [EMAIL PROTECTED]; beginners@perl.org Subject: Re: CSV Help I guess I'm referring to a spreadsheet then, if a csv does not have those options. Brian Bernard Senior, Direct Advanced Response Team Premier Support - Enterprise Research In Motion Limited Direct Dial: 1-519-888-7465 x5654 Email: [EMAIL PROTECTED] /* Sent using my BlackBerry 8700 */ ----- Original Message ----- From: Charles K. Clarkson To: beginners@perl.org Sent: Thu Dec 22 02:04:16 2005 Subject: RE: CSV Help Brian Bernard <mailto:[EMAIL PROTECTED]> wrote: : Hello, : : I am new to this list. Can someone please let me know if the built-in : functionality of Perl can print OUT to CSV but control what the CSV : looks like? Actually, I know that I can output to CSV but I want the : first row in the CSV to be a certain color and the text to be a : certain color also. If I can maximize the cells through the script to : be as big as the largest entry, that would also be preferred. : : Please let me know if this can be done. What do you mean by CSV? I think it is a comma separated values file. In such a file, color is meaningless. Perhaps I misunderstand the questions or perhaps you are referring print out a CSV, not printing to a CSV. Can you clarify? HTH, Charles K. Clarkson -- Mobile Homes Specialist 254 968-8328 -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
