3 ms·
'It can't deal properly with multi-line strings and spaces' Works fine in excel 2011 for mac: $ cat test.csv abc,"def ghi",jkl mno,pqr,st
by niggler 14y ago
'It can't deal properly with multi-line strings and spaces'
Works fine in excel 2011 for mac:
$ cat test.csv
abc,"def
ghi",jkl
mno,pqr,stu
$ open -a Microsoft\ Excel test.csv
http://imgur.com/CRUJZ57 http://imgur.com/CRUJZ57
This is an example of a poorly laid-out menu structure. To force it to do the right thing, you have to wrap text (right click -> format cells -> alignment -> "Wrap text" on).
Basically, the default rendering is supposed to be a single space for any whitespace (tab, newline, space) and "wrap text" forces it to do the right thing.
Shameless plug: I'm actually working on an XLSX parser: http://niggler.github.io/js-xlsx/ http://niggler.github.io/js-xlsx/