Encoding to UTF-8

library(readxl)

library(reshape2)

setwd("C:/R-studio")


df_db <- read_excel("Working_X.xlsx", sheet = "Accounts_DB")
col <- colnames(df_db[,1:18])


m_db <- melt(df_db, col, na.rm = TRUE, value.name = "Value" )

Created on 2020-05-10 by the reprex package (v0.3.0)

After reading an excel file I get a tibble on which I can see the characters written in my native language(Armenian). But after I melt the tibble, the characters become messed. I guess the issue is about encoding, and I need to change encoding to UTF-8, but whatever I searched for and tried I could not manage to conduct the change.

1 Like

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