How to use read.xls in R
Lisa Wang said the following on 12/7/2006 3:01 PM:
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.
Please reread ?read.xls. Quote from the "Note" section: "Either a working version of Perl must be present in the executable search path, or the exact path of the perl executable must be provided via the perl argument. See the examples below for an illustration." You need to install perl. http://www.activestate.com/Products/ActivePerl/Download.html HTH, --sundar