[R] Yet another question about importing Excel *.xls files

[Gabor Grothendieck]

The error message says that it can't find perl on your system so
either you don't have perl or its not on your path.  If you don't have
it at all install it. If its not on your path either add it to your
path or use the perl= argument to read.xls to tell it where to find
perl.  One of the examples in the example section of ?read.xls
illustrates use of the perl argument.

On Thu, Jan 21, 2010 at 11:20 AM, Jerry Floren <jerry.floren at state.mn.us> wrote:
>
> Hi Gabor,
>
> Thanks for all of your help and the additional code. Sorry, about the
> confusion on my part about the directory and file names.
>
> Since my first posts, I have simplified file names, directory names, and the
> spreadsheets by removing all the worksheets but the one needed. I tried this
> code, but had the same error messages:
>
>> library(gdata)
>
> Attaching package: 'gdata'
>
>
>        The following object(s) are masked from package:utils :
>
>         object.size
>
>> read.xls("C:\\TestR\\Soiltest.xls", as.is = TRUE)
> Converting xls file to csv file... Error in system(cmd, intern = !verbose) :
> perl not found
> Error in file.exists(tfn) : invalid 'file' argument
>>
>
> Several times when loading packages, or even data, I see the "object(s) are
> masked" message. Is that significant?
>
> David Winsemius suggested that I need to install Perl. I hope to get that
> done today, but need to get approval before it can be installed. I am using
> Windows XP, but it looks like Strawberry Perl should work. I also use R
> version 2.9.2 (2009-08-24).
>
> Thanks,
>
> Jerry Floren
> Minnesota Department of Agriculture
>
>
> --
> View this message in context: http://n4.nabble.com/Yet-another-question-about-importing-Excel-xls-files-tp1018699p1049897.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.
>