Advertisement
Guest User

Untitled

a guest
Oct 27th, 2016
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. library(RCurl)
  2. if (Sys.getenv("JAVA_HOME")!="")
  3. Sys.setenv(JAVA_HOME="")
  4. library(rJava)
  5. library(XLConnect)
  6. appURL <- "http://www.rba.gov.au/statistics/tables/xls-hist/1995-1998.xls"
  7. f = CFILE("19951998.xls", mode="wb")
  8. curlPerform(url = appURL, writedata = f@ref, ssl.verifypeer = FALSE)
  9. close(f)
  10. FX19951998 <- readWorksheetFromFile(file = "19952008.xls", sheet = "data",
  11. header = TRUE,
  12. startRow = 11, startCol = 1, endCol = 6, endRow = 1026)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement