[R] import Excel file ?

Shawn Way sway at tanox.com
Tue Apr 20 16:44:27 CEST 2004

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
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
PLEASE do read the posting guide!

More information about the R-help mailing list