Beefy Boxes and Bandwidth Generously Provided by pair Networks
Think about Loose Coupling

csv font and center

by ShermW0829 (Sexton)
on Apr 01, 2013 at 15:08 UTC ( #1026500=perlquestion: print w/replies, xml ) Need Help??
ShermW0829 has asked for the wisdom of the Perl Monks concerning the following question:

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;


Replies are listed 'Best First'.
Re: csv font and center
by marto (Archbishop) on Apr 01, 2013 at 15:11 UTC
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.
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!

      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.


Re: csv font and center
by 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.

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1026500]
Approved by marto
and the sunlight beams...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (5)
As of 2018-05-20 18:26 GMT
Find Nodes?
    Voting Booth?