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

[Patrick Hausmann]

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