Using the R tool, I was able to open an XLS file as follows:
require(xlsx)
coln = function(x) {
y = rbind(seq(1, ncol(x)))
colnames(y) = colnames(x)
rownames(y) = "col.number"
return(y)
}
data = read.xlsx2(path, 1)
coln(data)
x = 3
data = read.xlsx2(path, 1, colClasses = c(rep("character", x), rep("numeric", ncol(data)-x+1)))
I can see everything on my worksheet. But I would like to get only the data from column A and only then use the data from column B to compute a function.
How can I get this information separate?