[R] Excel files

ramelan thiagarajah ramelan3 at yahoo.co.uk
Wed Oct 25 21:46:33 CEST 2006


Hi every one,

I am very very new to R and solicit your kind help

I am trying to use my excel files in R. I used the
Xlread/write package and able to load the a sample
file into console. Then I tried to find the mean of a
column vector for example. But I could not proceed

Here is the problem
 rfile <- "Trial1.xls"
> read.xls( rfile, colNames = TRUE, sheet = 1, type =
"data.frame", from = 1 )
  x y  z
1 4 7  9
2 5 7 10
3 6 9 11

I request your help to find mean of column x 

With warm regards

Milan


Send instant messages to your online friends http://uk.messenger.yahoo.com



More information about the R-help mailing list