Re: [R] trying to import xls or xlsx files

2011-06-24 Thread Ivan Calandra
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:

[R] trying to import xls or xlsx files

2011-06-23 Thread wwreith
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

Re: [R] trying to import xls or xlsx files

2011-06-23 Thread Gabor Grothendieck
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

Re: [R] trying to import xls or xlsx files

2011-06-23 Thread 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_will...@bah.com wrote: library(xlsReadWrite)

Re: [R] trying to import xls or xlsx files

2011-06-23 Thread David Winsemius
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