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
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
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.
>