When writing a dataframe from Rstudio using RDCOMCLIENT to Excel, why do special characters appear?

edit

Special characters may appear when writing a dataframe from Rstudio to Excel using RDCOMCLIENT due to encoding issues. Excel may use a different encoding for text compared to R, causing certain characters (e.g. non-ASCII characters, quotation marks, etc.) to appear differently in Excel. To avoid this, it is recommended to use a consistent encoding when working with text data in R and Excel or to specifically set the encoding when exporting the dataframe to Excel.