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
wrote:
> Try this. pattern = "EWSB" says to ignore everything in the file
> before the first line containing EWSB. It then reads the
> rema
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
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
3 matches
Mail list logo
