[R] importing excel-file
brown_emu at yahoo.com
Wed Apr 18 19:37:44 CEST 2007
I use gdata and it works quite well for me. It's as easy as
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:
--- 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.
> 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
> PLEASE do read the posting guide
> and provide commented, minimal, self-contained, reproducible code.
More information about the R-help