dataTableToCsv escapes any commas embedded in the data values by quoting the whole value, to avoid confusion with the comma separator. There is not a way to specify an alternative separator. You'd have to convert the csv file to another format outside of Google Charts.
While commas and double quotes are handled correctly, I notice that newlines (\n) are not. On Mon, Sep 18, 2017 at 7:10 PM, Andrea Grillini <[email protected]> wrote: > I notice dataTableToCsv produces an output where columns values in the > same row are separated with commas. > As a result, when somebody opens the csv file with Microsoft Excel columns > are not recognized automatically as I could see with LibreOffice Calc. > I saw in order to see Microsoft Excel automatically find the columns > semicolons instead of commas are needed. > Is there a way to tell dataTableToCsv to use semicolons instead of commas? > > Thanks in advance! :-) > > > A. > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to google-visualization-api@ > googlegroups.com. > Visit this group at https://groups.google.com/ > group/google-visualization-api. > To view this discussion on the web visit https://groups.google.com/d/ > msgid/google-visualization-api/7418172e-5fca-4f33-8ba4- > 644f9dc6d376%40googlegroups.com > <https://groups.google.com/d/msgid/google-visualization-api/7418172e-5fca-4f33-8ba4-644f9dc6d376%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> [email protected] <[email protected]> 5CC, Cambridge MA -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/google-visualization-api. To view this discussion on the web visit https://groups.google.com/d/msgid/google-visualization-api/CAOtcSJO01Us4-_EYM-g2K7QhDsiwrVndxemHFpe3jy7r141AWg%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
