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 <[EMAIL PROTECTED]> 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@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@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@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.