Googlesheets4 to read cells with Arabic content

Hello my friends,
I'm trying to read google sheet via package Googlesheets4. No problem with all columns but there is a column that has some cells in Arabic. How can i read it as Arabic in the dataframe
the code i used is ,

DF = read_sheet(ss)
DFNew = mutate(DF , Code = as.character(Code))

the column is as in the screenshot
remaining english cells same as is
Could you please help me , i tried many solutions but no answer
thanks in advance

Please see the FAQ: What's a reproducible example (`reprex`) and how do I do one? Using a reprex, complete with representative data will attract quicker and more answers. Without one it's hard to provide very specific guidance.

Section 11.3.2 of R for Data Science has a good explainer on string encoding and the use of flexible packages like readr to handle them. Be sure to check that the configuration of R if you are using it directly or the RStudio configuration is set to the UTF-8 default.

1 Like

Hi, I solved this (not english word) with development version of gargle package.

see this,


1 Like

thanks @technocrat for our support

1 Like

Hey @jhk0530 , Seems this is the best solution , i will try it now
thanks and appreciated

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.