Displaying 1 result from an estimated 1 matches for "getexcel".
2004 Oct 25
1
.Rprofile and RODBC
...0 I've had the following 2 issues
I can't find solutions for. I'm using Windows XP.
1) R 1.9 continues to read my .Rprofile file in my
home directory but R 2.0 does not. How do I get R 2.0
to do this?
2) The following function no longer works in R 2.0 but
continues to work in R 1.9:
getExcel <- function (x) {
invisible(require(RODBC))
x <- sqlFetch(odbcConnectExcel(file.choose()),
"exceldata", na.strings = "NA")
odbcCloseAll() #closes the connection
invisible(edit(x))
}
I use this function to choose an Excel file and open
it using an ODBC connection. Why...