Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

csv font and center

by ShermW0829 (Acolyte)
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;


Comment on csv font and center
Replies are listed 'Best First'.
Re: csv font and center
by marto (Bishop) 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 (Bishop) 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 web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (9)
As of 2015-10-13 07:28 GMT
Find Nodes?
    Voting Booth?

    Does Humor Belong in Programming?

    Results (296 votes), past polls