[R] importing data in excel

Marta Rufino mrufino at ipimar.ualg.pt
Mon Aug 30 12:32:36 CEST 2004

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


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

More information about the R-help mailing list