[R] Need to read an Excel File

Gabor Grothendieck ggrothendieck at gmail.com
Fri Jul 30 18:33:01 CEST 2010


On Fri, Jul 30, 2010 at 8:39 AM, rajibshibly <rajibshibly at yahoo.com> wrote:
>
> I am trying to read an Excel file using the following:
> a<-read.xls("mydata.xls", sheet=1)
>
> The file mydata.xls is stored in the working directory. However I am getting
> the following error. Can anyone help.
>
> Error in findPerl(verbose = verbose) :
>  perl executable not found. Use perl= argument to specify the correct path.
> Error in file.exists(tfn) : invalid 'file' argument
>

The error message seems self explanatory.  It says it could not find
perl and it is advising you to use the perl= argument of read.xls to
specify where perl is.  Alternately add perl to your path so it can
find it.

The ?read.xls help page includes examples of using the perl argument.

Please ensure you communicate which package you are using next time (I
gather from the context its gdata but it might not be obvious).



More information about the R-help mailing list