4 ms·

Why are you using Excel and not .txt or .csv directly?

• bazzargh 13y ago
  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/spreadsheets#Google_Spreadsheets_as_a_Data_Source 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-feeds-from-excel-services-2013-in-powerpivot/ http://cwebbbi.wordpress.com/2012/07/24/consuming-odata-feed...
  • teamonkey 13y ago
    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.
• teamonkey 13y ago
  I mean that I want to use Excel as a spreadsheet and use its contents to drive a D3 diagram without the current hassle of getting the data out of Excel into a format that D3 can read cleanly (and continuously - if I update the spreadsheet, the diagram should also update).