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 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Emilie Haon.Lasportes Sent: Tuesday, April 20, 2004 9:29 AM To: [EMAIL PROTECTED] 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 ______________________________________________ [EMAIL PROTECTED] 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 ______________________________________________ [EMAIL PROTECTED] 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
