[R] importing data in excel

[Warnes, Gregory R]

If you need to load Excel data *into* R, you can use the read.excel()
function in the gregmisc package (note that Perl must be installed) to read
MS-Excel .xls files.  


A better option is to simply save the data out as a tab-delimited text file
and then use

read.table(file="<filename>", sep="\t")

If you want to save R data in a form that MS-Excel will be happy with, use

write.table( <object>, file="<filename>.xls", sep="\t"))

-Greg

 

-----Original Message-----
From: r-help-bounces at stat.math.ethz.ch
To: Gerardo Prieto Blanco
Cc: R-help at stat.math.ethz.ch
Sent: 8/29/04 2:04 PM
Subject: Re: [R] importing data in excel

Gerardo Prieto Blanco wrote:

> Hello, I need to care excel data to be used
> in R,..., how do I make it?
> Thank you and greetings, Gerardo Prieto

Please read the R Data Import/Export manual!

Uwe Ligges


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

______________________________________________
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


LEGAL NOTICE\ Unless expressly stated otherwise, this messag...{{dropped}}