[R] importing excel-file

[Stephen Tucker]

I use gdata and it works quite well for me. It's as easy as

install.packages(gdata)
library(gdata)
data = read.xls("mydata.xls",sheet=1) 

[read.xls() can take other arguments]

It requires concurrent installation of Perl, but installing Perl is also
simple. For Windows, you can get it here:
http://www.activestate.com/Products/ActivePerl/


--- Gabor Csardi <csardi at rmki.kfki.hu> wrote:

> There is also a read.xls command in package gdata, it seems that it uses
> a perl script called 'xls2csv'. I've have no idea how good this is,
> never tried it.
> 
> Btw, xlsReadWrite is Windows-only, so you can use it only if 
> you use windows.
> 
> Gabor
> 
> ps. Corinna, to be honest, i've no idea what kind online help you've
> read, there is plenty. Next time try to be more specific please. 
> 
> On Wed, Apr 18, 2007 at 03:07:51PM -0200, Alberto Monteiro wrote:
> > Corinna Schmitt wrote:
> > > 
> > > It is a quite stupid question but please help me. I am very 
> > > confuced. I am able to import normal txt ant mat-files to R but 
> > > unable to import .xls-file
> > > 
> > I've tried two ways to import excel files, but none of them
> > seems perfect.
> [...]
> 
> -- 
> Csardi Gabor <csardi at rmki.kfki.hu>    MTA RMKI, ELTE TTK
> 
> ______________________________________________
> R-help at stat.math.ethz.ch 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.
>