I'm importing .xlsx files in to R and when I enter print data command I get a mess with specific symbols. The file opens nicely with excel. This is the code I use:
library("xlsx")
data <-read.xlsx("file.xlsx", sheetIndex = 1)
print(data)
I don't have access to your data so I cannot check:
data <- xlsx::read.xlsx("file.xlsx", sheetIndex = 1, encoding="UTF-8")
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With