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, however, still is somewhat messy.
> 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
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 for some advice on h
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 some
4 matches
Mail list logo
