Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical

Re: Alt + Enter

by ninja2k (Initiate)
on Feb 08, 2013 at 06:23 UTC ( #1017770=note: print w/ replies, xml ) Need Help??

in reply to Alt + Enter

All, got this sorted out today, looks like years late but ok. Correct syntax to make this work is as follows:

print "Column 1,\"Column 2\nline 2\nline 3\",Column 3\n";

Print this out to a csv file, open the csv with excel, auto adjust the columns, then auto adjust the row height and you will see the results. This works every time for Perl v5.10.1 and Excel 2007

Comment on Re: Alt + Enter
Download Code

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1017770]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (4)
As of 2016-05-01 09:22 GMT
Find Nodes?
    Voting Booth?

    No recent polls found