Actually sep = "," and header = TRUE are the defaults so its just
DF <- read.xls(v, pattern = "EWSB") On Sat, Jan 17, 2009 at 9:57 AM, Gabor Grothendieck <ggrothendi...@gmail.com> wrote: > Try this. pattern = "EWSB" says to ignore everything in the file > before the first line containing EWSB. It then reads the > remainder read.table style into data frame DF. > > library(gdata) > v <- "http://www.statistics.gov.uk/elmr/01_09/downloads/Table1_07.xls"; > DF <- read.xls(v, pattern = "EWSB", sep = ",", header = TRUE) > > > > On Sat, Jan 17, 2009 at 9:40 AM, simeon duckworth > <simeonduckwo...@gmail.com> wrote: >> I am trying to figure out a way to download an Excel file and then read a >> range into R - so that i can 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) >> close(channel) >> >> very grateful for any help >> >> simeon >> >> [[alternative HTML version deleted]] >> >> ______________________________________________ >> R-help@r-project.org mailing list >> https://stat.ethz.ch/mailman/listinfo/r-help >> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html >> and provide commented, minimal, self-contained, reproducible code. >> > ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
