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 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.
