[R] How to use read.xls in R

[Gabor Grothendieck]

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