csv font and center

[ShermW0829]

I probably missed it when reviewing Text::CSV but within a cell can I set a font of 14 and center text when using PERL to create a .csv file?

Thank you;

Sherman

[marto]

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

[CountOrlok]

No. You are probably confusing CSV with HTML or some other rich text file format.

[ww]

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 (-   -).

[ShermW0829]

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

[sundialsvc4]

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.