[R] Excel *.xls files, RODBC
dieter.menne at menne-biomed.de
Sat Dec 4 18:26:29 CET 2004
> z <- odbcConnectExcel("c:/myfolder/mydata.xls")
> myframe <- sqlFetch(z, "Sheet1")
I found the reading of whole sheets somewhat unsafe, so I always create a named
range (here: data) including header and do the following.
Never had problems with this.
channel = odbcConnectExcel("macronutrients.xls")
ac = sqlQuery(channel,"select * from data")
More information about the R-help