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
--
View this message in context:
http://r.789695.n4.nabble.com/Need-to-read-an-Excel-File-tp2307915p2307915.html
Sent from the R help mailing list archive at Nabble.com.
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).
2010/7/30 rajibshibly <rajibshibly at yahoo.com>:> > I am trying to read an Excel file using the following: > a<-read.xls("mydata.xls", sheet=1)[snip]> Error in findPerl(verbose = verbose) : > ?perl executable not found. Use perl= argument to specify the correct path. > Error in file.exists(tfn) : invalid 'file' argumentThe 'read.xls' function in the the xlsReadWrite package (Win32 only) doesn't have external dependencies. Might be an option as well. Cheers, Hans-Peter
To be able to import excel-files into R you also need to download Perl from http://www.perl.org/. From this link you will have to downlaod a suitable Strawberry based on the computer you use (Mac/Window). Once installed you should be able to move on. -- View this message in context: http://r.789695.n4.nabble.com/Need-to-read-an-Excel-File-tp2307915p4662778.html Sent from the R help mailing list archive at Nabble.com.
I have found that the easiest way to read/write Excel files is to use the XLConnect package. Sent from my iPad On Mar 28, 2013, at 15:54, Henry Njovu <hnjovu at mwekawildlife.org> wrote:> To be able to import excel-files into R you also need to download Perl from > http://www.perl.org/. From this link you will have to downlaod a suitable > Strawberry based on the computer you use (Mac/Window). Once installed you > should be able to move on. > > > > -- > View this message in context: http://r.789695.n4.nabble.com/Need-to-read-an-Excel-File-tp2307915p4662778.html > Sent from the R help mailing list archive at Nabble.com. > > ______________________________________________ > R-help at r-project.org 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.