[R] Reading data from xls..........please help
petr.pikal at precheza.cz
Fri Jun 18 13:42:45 CEST 2010
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
> 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
Select data you want to transfer to R
to copy it to clipboard
Open R and write
mydata <- read.delim("clipboard")
> 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
> > >
> > > 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
> PLEASE do read the posting guide
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help