Displaying 2 results from an estimated 2 matches for "exceldata".
Did you mean:
excel_data
2004 Oct 25
1
.Rprofile and RODBC
...s 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 does this not work
now?
Thanks in advance for you help.
~Nick
2007 Apr 27
0
[ANN:] new package xlsReadWrite*Pro*: announce + update.
...otivated by Mark W. Kimpel)
- new argument "formulasAsValues = TRUE". This high level setting can
be overriden by the (new) colClasses argument formula.
- (read.xls/write.xls) new colClasses argument "formula" to read and
write formulas.
Will be auto-determined from Exceldata and
(motivated by Jeff Laake)
- argument "cells" extended to accept character vector for
*named ranges* and a numeric R1C1R2C2 range vector.
- "xls.range" to retrieve information about named ranges.
(motivated by Michael Clifford)
- "xls.images&q...