[sf-perl] writing a csv file: how do i embed a newline in a cell?

Paul Makepeace Paul.Makepeace at realprogrammers.com
Sun Apr 10 06:15:30 PDT 2011


A heartfelt plea from the trenches...

Please, please do not write or use anything that produces CSV output!
There is no unicode standard around it and you WILL run into accented
character and interop issues with it. Yes, English has accented
characters(!) Also, as you've seen programs tend to be dumb about
interpreting CSV.

XLS gets UTF-8 right and is the best solution here.

Paul

On Sat, Apr 9, 2011 at 01:52, George Hartzell <hartzell at alerce.com> wrote:
> Alternatively, use Spreadsheet::WriteExcel or the newer
> Excel::Writer::XLSX and generate an excel file directly.


More information about the SanFrancisco-pm mailing list