import xlsx into r code example
Example 1: how to read excel file in r
library("readxl")
my_data <- read_excel("my_file.xls")
my_data <- read_excel("my_file.xlsx")
Example 2: read xlsx in r
require(xlsx)
read.xlsx("myfile.xlsx", sheetName = "Sheet1")
read.xlsx2("myfile.xlsx", sheetName = "Sheet1")
Example 3: read xlsx in r
require(xlsx)
coln = function(x) {
y = rbind(seq(1, ncol(x)))
colnames(y) = colnames(x)
rownames(y) = "col.number"
return(y)
}
data = read.xlsx2("myfile.xlsx", 1)
coln(data)
x = 3
data = read.xlsx2("myfile.xlsx", 1,
colClasses = c(rep("character", x), rep("numeric", ncol(data)-x+1))
)