How to use read.xls in R
Or alternatively you can use xlsReadWrite package
install.packages(xlsReadWrite)
library(xlsReadWrite)
read.xls("sampledata.xls")
Regards,
Francisco
Dr. Francisco J. Zagmutt
College of Veterinary Medicine and Biomedical Sciences
Colorado State University
Gabor Grothendieck wrote:
You need perl installed for it to work.
Although you normally would not need to use them note the
verbose= and perl= arguments on the read.xls command.
If you don't want to install perl try using RODBC:
library(RODBC)
z <- odbcConnectExcel("/a.xls")
dd <- sqlFetch(z,"Sheet1")
close(z)
On 12/7/06, Lisa Wang <lisawang at uhnres.utoronto.ca> wrote:
Hello there,
In gdata package, read.xls is to be used for reading excel data (from
windows).
The following is my code:('C:/session/sampledata.xls' is where the file
is stored)
data1<-read.xls('C:/session/sampledata.xls',sheet=1)
and I got the following error message:
Error in system(cmd, intern = !verbose) : perl not found
Could you please tell me what I have done wrong and how I should do it?
Thanks a lot
Lisa Wang
Princess Margaret Hospital, Toronto, Ca
tel:416 946 4551
______________________________________________ R-help at stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
______________________________________________ R-help at stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.