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 <erich.neuwi...@univie.ac.at> wrote: > 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 <govo...@gmail.com <javascript:;>> wrote: > > > > 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 changes to the tables. > > Since most of my colleagues live in the M$ Excel - world I tend to use > > Excel 2011 as well. However, Excel does not handle UTF-8 (which I like > > because of different system locales). > > So I actually do a write.csv with file-encoding in macroman, but even > then > > Excel won't just open it and I will have to work my way through the > > import-dialogue. > > > > The other way around, it's even worse. I save the spreadsheet as > macroman, > > iconv it to utf-8 and then read.csv it to R. > > > > It works, but it's just really messy. Is there a (preferably > light-weight) > > csv-spreadsheet Editor for Mac OS that you use? Open-Office? I would like > > NOT to actually buy another Excel version. However, for collaboration, a > > xls-export would be phenomenal. > > > > Thanks! > > > > Kai > > > > [[alternative HTML version deleted]] > > > > ______________________________________________ > > R-help@r-project.org <javascript:;> mailing list -- To UNSUBSCRIBE and > more, see > > https://stat.ethz.ch/mailman/listinfo/r-help > > PLEASE do read the posting guide http://www.R-project.org/ > posting-guide.html > > and provide commented, minimal, self-contained, reproducible code. > > -- http://hadley.nz [[alternative HTML version deleted]] ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
