Displaying 1 result from an estimated 1 matches for "table1_07".
2009 Jan 17
1
Downloading Excel file & reading a range
...an have a reasonably automated process. I have
been trying to use the RODBC package, but with little success. I suspect
that this isnt the right route
Here is some code. My aim is to read in the data starting in H69:H283 in
sheet 2.
v<-"http://www.statistics.gov.uk/elmr/01_09/downloads/Table1_07.xls"
dest<-"C:/Data/onstest.xls"
download.file(url=v,destfile=dest,mode="wb")
library(RODBC)
channel <-odbcConnectExcel(dest)
qry <- paste("SELECT * FROM '",tbls$TABLE_NAME[2],"'",sep="")
onstest <- sqlQuery(channel,qry)
cl...