write.csv with encoding UTF8
<p>I am using Windows7 Home Premium and R Studio 0.99.896.
I have a csv file containing a column with text in several different languages eg english, european, korean, simplified chinese, traditional chinese, greek, japanese etc.</p>

<p>I read it into R using</p>

<p><code>table&lt;-read.csv("broker.csv",stringsAsFactors =F, encoding="UTF-8")</code></p>

<p>so that all the text is readable in it's language.</p>

<p>Most of the text is within a column called named "content". Within the console, when I have a look</p>

<p><code>toplines&lt;-head(table$content,10)</code></p>

<p>I can see all the languages as they are, but when I try to write to a csv file and open it in excel, I can no longer see the languages. I typed in</p>

<p><code>write.csv(toplines,file="toplines.csv",fileEncoding="UTF-8")</code>    </p>

<p>then I opened toplines.csv in excel 2013 and it looked liked this</p>

<pre><code>1   [&lt;U+5916&gt;&lt;U+5A92&gt;:&lt;U+4E2D&gt;&lt;U+56FD&gt;&lt;U+6C1.....
2   [&lt;U+4E2D&gt;&lt;U+56FD&gt;&lt;U+6C11&gt;&lt;U+822A&gt;&lt;U+51C6.....
3   [&lt;U+5916&gt;&lt;U+5A92&gt;:&lt;U+4E2D&gt;&lt;U+56FD&gt;&lt;U+6C1.....
</code></pre>

<p>and so forth</p>

<p>Would anyone be able to tell me how I can write to a csv or excel file so that the languages that can be read as they are in Excel 2013? Thank you very much.</p>