Hi Charles, CSV is just data as text. There is no capacity for formatting. You can write a macro for your spreadsheet program to automate formatting the imported data, or you can switch to a Perl package which produces Excel (or other compatible) files rather than CSV.
If you decide to switch to Excel format, you may need to install a module from CPAN: http://search.cpan.org/search?query=spreadsheet&mode=all David Luke, Application Developer IV ISOCORP, Inc. DMS Enterprise Information Technology Services Building 4030, Suite 115 4050 Esplanade Way Tallahassee, Florida 32399-0950 (850) 922-7587 -----Original Message----- From: Charles K. Clarkson [mailto:[EMAIL PROTECTED] Sent: Thursday, December 22, 2005 2:04 AM To: beginners@perl.org 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>
