Displaying 1 result from an estimated 1 matches for "10_11".
Did you mean:
1011
2011 Jul 20
1
Problem with RODBC
...m. One
complication is that the header row of this sheet is comprised of
dropdown boxes.
I tried what I normally would do plus some variations. Here is the output.
> require(RODBC)
> options(stringsAsFactors = FALSE)
> fileName <- paste(getwd(),
+ "/../Data/10_11 Quality Threshold Calculations v3.xls",
+ sep = "")
> channel <- odbcConnectExcel(fileName)
> sqlTables(channel)$TABLE_NAME
[1] "Data$"
[2] "PBC$"
[3] "SQL$"
[4] "'10_11 Summary$'"
[5] "'1...