[R] R-excel

Prof Brian Ripley ripley at stats.ox.ac.uk
Sat Aug 11 07:58:18 CEST 2007

On Fri, 10 Aug 2007, Peter Wickham wrote:

> I am running R 2.5.1 using Mac OSX 10.4.10. "xlsReadWrite" is a Windows
> binary. Instead, install and load packages: (1) "gtools":(2) "gdata". These
> are both Windows and Mac binaries. "gdata" depends on "gtools", so be sure
> to load "gtools" first or set the installation depends parameters. Then you

The R default *is* to install dependencies in R >= 2.5.0.

> can use "read.xls".  Thus, in Mac: "data<-read.xls("/Users/your
> name/Documents/data.xls",sheet=1). For Windows, substitute the appropriate
> filepath and file name in the first argument of "read.xls": e.g.,
> "data<-read.xls("A:/filename.xls",sheet-1)". Thanks to correspondents for

You mean sheet=1 ....

There are other platforms, and the usage of gdata::read.xls is common to 
all platforms.

> their advice; but I hope that this may alleviate some of the frustration
> (referred to in the R Import/Export Manual) associated with dealing with

That is described in the 'R Data Import/Export Manual' (sic).

It *increases* the frustration of those who WTFM to see it and its 
contents misdescribed in this way.  Further, people who search the list 
archives are liable to make use of buggy posts like this one, so it seems 
necessary to put the corrections and frustration on the record.

Please just point people to the appropriate manual

> EXCEL files in R.
> Erika Frigo wrote:
>> Good morning to everybody,
>> I have a problem : how can I import excel files in R???
>> thank you very much
>> Dr.sa. Erika Frigo
>> Università degli Studi di Milano
>> Facoltà di Medicina Veterinaria
>> Dipartimento di Scienze e Tecnologie Veterinarie per la Sicurezza
>> Alimentare (VSA)
>> Via Grasselli, 7
>> 20137 Milano
>> Tel. 02/50318515
>> Fax 02/50318501
>> 	[[alternative HTML version deleted]]
>> ______________________________________________
>> 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.

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

More information about the R-help mailing list