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

From: Petr PIKAL <petr.pikal_at_precheza.cz>
Date: Fri, 18 Jun 2010 13:42:45 +0200

Hi

r-help-bounces_at_r-project.org napsal dne 16.06.2010 22:14:33:

> 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?

Do you have Excel? If yes you can

Open Excel
Select data you want to transfer to R
Press

Ctrl-C

to copy it to clipboard
Open R and write

mydata <- read.delim("clipboard")

to console.

Regards
Petr

>
>
> 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.



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 - 11:45:17 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