[R] trying to import xls or xlsx files

[Abhijit Dasgupta]

Gabor's answer explains the error perfectly. You might want to look at the xlsx package as well as the RODBC package if you're on Windows. RODBC is really fast, if you can use it. 

Abhijit

On Jun 23, 2011, at 2:00 PM, wwreith <reith_william at bah.com> wrote:

> library(xlsReadWrite)
> mydata<-read.xls("file path", header=TRUE)
> 
> however if I change xls to csv it works just fine. Any ideas what I'm doing
> wrong? I have have also using the package gdata with the exact same error.
> 
> Below is the error that pops up.
> 
> 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/trying-to-import-xls-or-xlsx-files-tp3620580p3620580.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.