Re: [R] trying to import xls or xlsx files
This is true if the original problem was with gdata::read.xls(). But xlsReadWrite was loaded, and this package doesn't use Perl to read an xls file. Is there a confusion somewhere? Ivan Le 6/24/2011 03:56, David Winsemius a écrit : On Jun 23, 2011, at 2:00 PM, wwreith 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 Your error message suggests you do not have a suitable version of Perl installed. -- Ivan CALANDRA PhD Student University of Hamburg Biozentrum Grindel und Zoologisches Museum Dept. Mammalogy Martin-Luther-King-Platz 3 D-20146 Hamburg, GERMANY +49(0)40 42838 6231 ivan.calan...@uni-hamburg.de ** http://www.for771.uni-bonn.de http://webapp5.rrz.uni-hamburg.de/mammals/eng/1525_8_1.php __ R-help@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.
[R] trying to import xls or xlsx files
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@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.
Re: [R] trying to import xls or xlsx files
On Thu, Jun 23, 2011 at 2:00 PM, wwreith reith_will...@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 Regarding the read.xls in gdata the error message means that either perl is not installed or else its not on your path. If its in ~/bin/perl, say, then try: library(gdata) DF - read.xls(myfile, ...whatever..., perl = ~/bin/perl) or if you are on Windows and its in C:\Perl\bin\perl.exe, say, then try: library(gdata) DF - read.xls(myfile, ...whatever..., perl = C:\\Perl\\bin\\perl.exe) Alternately put perl on your path and then you can omit the perl= argument. -- Statistics Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com __ R-help@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.
Re: [R] trying to import xls or xlsx files
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_will...@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@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. __ R-help@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.
Re: [R] trying to import xls or xlsx files
On Jun 23, 2011, at 2:00 PM, wwreith 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 Your error message suggests you do not have a suitable version of Perl installed. -- David Winsemius, MD West Hartford, CT __ R-help@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.