[R] How to use read.xls in R

[Sundar Dorai-Raj]

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