csv font and center

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

Replies are listed 'Best First'.
Re: csv font and center by marto (Cardinal) on Apr 01, 2013 at 15:11 UTC
No, a csv file has no concept of font faces or sizes. You probably want to use Excel or some other spreadsheet program. See Excel::Writer::XLSX, Spreadsheet::WriteExcel, Super Search for more discussion. Update: fixed typo	[reply]
Re: csv font and center by CountOrlok (Friar) on Apr 01, 2013 at 15:12 UTC
No. You are probably confusing CSV with HTML or some other rich text file format.	[reply]
Re: csv font and center by ww (Archbishop) on Apr 01, 2013 at 15:21 UTC
You have several ways to find the answer to your own question... and should recall that that kind of self-help is highly valued here. The very first approach might be to reread the doc re Text::CSV; another might be to apply Super Search to your problem; a third might be to use BigG.... The bottom line is that you don't seem to have done much to helpyourself (- -). If you didn't program your executable by toggling in binary, it wasn't really programming!	[reply]
Re^2: csv font and center by ShermW0829 (Sexton) on Apr 01, 2013 at 21:32 UTC
I apologize, ww. I did a search on csv and found Text::CSV among others so I ended my search there. Since I don't use Excel I didn't look for that. Thank you for your input. Sherman	[reply]
Re: csv font and center by locked_user sundialsvc4 (Abbot) on Apr 01, 2013 at 18:54 UTC
CSV = Comma Separated Values, is nothing more or less than a data-exchange format ... mostly concerned with what to do when the content of a particular data field contains either a comma or a newline. It has no notion of formatting. I guess from your post that what you’re really trying to do is to get data into an Excel spreadsheet. In this case, a tool such as Excel::Writer::XSLX might be more to your liking. The CSV file-format does not have (and was never intended to have) the expressiveness that your present requirement appears to demand. You should also consider whether it would be appropriate (in a Windows environment) to use OLE. Launch “Excel, itself,” tell it to create a Spreadsheet object, then feed data into it ... formatting and all. Tell Excel to save the spreadsheet and you are done.