[R] import Excel file ?

[Shawn Way]

If you want to just import the data and go, saving as a .csv file and
using read.csv (something like this) is the way to go.

If you are using a real-time file (open) or using a large excel file,
you may want to look at RODBC.  While this is a little harder to figure
out, it allows one to use SQL queries to retrieve the data needed from
excel and prevent overburdening R with data.

Shawn Way, PE
Engineering Manager
sway at tanox.com


-----Original Message-----
From: r-help-bounces at stat.math.ethz.ch
[mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Emilie
Haon.Lasportes
Sent: Tuesday, April 20, 2004 9:29 AM
To: R-help at stat.math.ethz.ch
Subject: [R] import Excel file ?


Good afternoon,

I would like to know how can I import Excel files in R ? Do I have to 
transform them in text files (.txt) ?
Thank you

Emilie Haon-Lasportes

______________________________________________
R-help at stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide!
http://www.R-project.org/posting-guide.html