Re: [R] workflow getting UTF-8 csv in and out of R on Mac (spreadsheet editor)

2016-09-02 Thread Hadley Wickham
You can use readr::write_excel_csv() which adds a BOM that forces excel to read as UTF-8. Hadley On Friday, September 2, 2016, Erich Neuwirth wrote: > read_excel in Hadley’s readxl package > should handle your encoding problems. > Writing Excel files on a Mac,

Re: [R] workflow getting UTF-8 csv in and out of R on Mac (spreadsheet editor)

2016-09-02 Thread John Kane
To: r-help@r-project.org > Subject: [R] workflow getting UTF-8 csv in and out of R on Mac > (spreadsheet editor) > > Hi all, > > I am hoping for some advice on how to handle UTF-8 spreadsheet files in a > Mac environment - sort of off-topic, but still relevant for hopefully a >

Re: [R] workflow getting UTF-8 csv in and out of R on Mac (spreadsheet editor)

2016-09-02 Thread Erich Neuwirth
read_excel in Hadley’s readxl package should handle your encoding problems. Writing Excel files on a Mac, however, still is somewhat messy. And you probably should post this kind of question on r-sig-mac On 02 Sep 2016, at 13:03, Kai Mx wrote: > > Hi all, > > I am hoping

[R] workflow getting UTF-8 csv in and out of R on Mac (spreadsheet editor)

2016-09-02 Thread Kai Mx
Hi all, I am hoping for some advice on how to handle UTF-8 spreadsheet files in a Mac environment - sort of off-topic, but still relevant for hopefully a bunch of people. I am using R on Mac OS 10.10. Sometimes I have the urge to actually look at a large spreadsheet on the big screen or make