[R] How to read an excel data into R?

From: Patrick Hausmann <c18g_at_zfn.uni-bremen.de>
Date: Thu 23 Jun 2005 - 19:11:05 EST


Hi,

you can use the library "RODBC" to import Excel-Files. This works for me:

#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
library(RODBC)
setwd("C:\\R1B2")
channel <- odbcConnectExcel("pk2003.xls") tab <- sqlFetch(channel, "Tabelle3")
#~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

HTH
Patrick



R-help@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 Received on Thu Jun 23 19:16:11 2005

This archive was generated by hypermail 2.1.8 : Fri 03 Mar 2006 - 03:32:58 EST