Re: [R] Reading data from xls..........please help

From: Joris Meys <jorismeys_at_gmail.com>
Date: Fri, 18 Jun 2010 14:02:03 +0200

If you're on windows and you never installed perl, then you don't have it. Another easy way to find out is to type "perl" in the search window under the start menu. If there's no perl.exe on your computer, you don't have it.

Take a look at : http://www.perl.org/

If you download Perl, it doesn't really matter that much whether you take the strawberry or the Activestate version. I took the ActiveState, but feel free to differ.

http://www.activestate.com/activeperl

Cheers
Joris

On Wed, Jun 16, 2010 at 10:14 PM, Christofer Bogaso <bogaso.christofer_at_gmail.com> wrote:
> Thanks for your reply. Possibly I donot have perl. I am not sure although.
> How I can find whether I have it? If I dont have it then where can I
> download it from?
>
>
> On Thu, Jun 17, 2010 at 12:57 AM, Barry Rowlingson <
> b.rowlingson_at_lancaster.ac.uk> wrote:
>
>> On Wed, Jun 16, 2010 at 7:29 PM, Christofer Bogaso
>> <bogaso.christofer_at_gmail.com> wrote:
>> > Can anyone help me how to read xls file into R. I have tried following
>> >
>> > library(gdata)
>> > xlsfile <- file.path(.path.package('gdata'),'xls','iris.xls')
>> > read.xls(xlsfile)
>> >
>> > I got following error:
>> > Converting xls file to csv file... Error in system(cmd, intern =
>> !verbose) :
>> > perl not found
>> > Error in file.exists(tfn) : invalid 'file' argument
>> >
>> > Question *1) What is the way to get it working?*
>>
>>  Works for me on an Ubuntu 9.10 with R 2.10.1, so swapping your OS and
>> R version to that will get it working... What OS/R are you on?
>>
>>  Note it says 'perl not found'. That's because it hasn't found perl.
>> Do you have perl on your system? Do you need to specify the path to
>> perl, as in the examples for Windows in help(read.xls)?
>>
>> Barry
>>
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
>

-- 
Joris Meys
Statistical consultant

Ghent University
Faculty of Bioscience Engineering
Department of Applied mathematics, biometrics and process control

tel : +32 9 264 59 87
Joris.Meys_at_Ugent.be
-------------------------------
Disclaimer : http://helpdesk.ugent.be/e-maildisclaimer.php

______________________________________________
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.
Received on Fri 18 Jun 2010 - 12:05:27 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 18 Jun 2010 - 12:10:32 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive