[R] R-excel

Peter Wickham peterwickham at mac.com
Sat Aug 11 02:33:26 CEST 2007


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

-- 
View this message in context: http://www.nabble.com/R-excel-tf3975982.html#a12101349
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list