how to read .xlsx file in r studio code example
Example 1: read xlsx in r
require(xlsx)
read.xlsx("myfile.xlsx", sheetName = "Sheet1")
read.xlsx2("myfile.xlsx", sheetName = "Sheet1")
Example 2: read xlsx in r
require(xlsx)
coln = function(x) { # A function to see column numbers
y = rbind(seq(1, ncol(x)))
colnames(y) = colnames(x)
rownames(y) = "col.number"
return(y)
}
data = read.xlsx2("myfile.xlsx", 1) # open the file
coln(data) # check the column numbers you want to have as factors
x = 3 # Say you want columns 1-3 as factors, the rest numeric
data = read.xlsx2("myfile.xlsx", 1,
colClasses = c(rep("character", x), rep("numeric", ncol(data)-x+1))
)