News for hackers. Stuff that matters.
Re:Raw: the missing link between spreadsheets and vector gra... by bazzargh on Wednesday October 02, 2013 @06:59AM (#6481711)
One good reason would be (as he says) that it is flaky. eg how does it handle newlines, commas, tabs and non-ascii characters in data? I've had to pull dirty data between systems before, and csv as the lowest common denominator tends to be lossy as there's no spec on this stuff. Some systems (eg oracle's csv import) do support forms of escaping, but they're not interoperable.

I see they support other file formats & json here, but a nice to have would be to use the google spreadsheet url: https://developers.google.com/chart/interactive/docs/spreads...

Grabbing data directly from Office365 is also possible: http://cwebbbi.wordpress.com/2012/07/24/consuming-odata-feed...

Re:Raw: the missing link between spreadsheets and vector gra... by teamonkey on Wednesday October 02, 2013 @11:27AM (#6482970)
The worst thing is that I work in a bilingual office. Excel's export to CSV does not work as intended when you have more than one number format.