[R] importing data in excel

[Marta Rufino]

What I do, is that I save it as a file separated by tab,
and read it in R using (I save it with the xls extension, because this way
the file is automaticly open by excell always, althought it is a text file):

read.table("file name.xls", head=T, sep="\t")


it might help if you replace all the empty cells of your table (in excell)
by NA

cheers,
Marta

----- Original Message ----- 
From: "Gerardo Prieto Blanco" <economia at adinet.com.uy>
To: <R-help at stat.math.ethz.ch>
Sent: Sunday, August 29, 2004 5:51 PM
Subject: [R] importing data in excel


> Hello, I need to care excel data to be used
> in R,..., how do I make it?
> Thank you and greetings, Gerardo Prieto
>
> ______________________________________________
> 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