[R] RODBC vs gdata

Christof Kluß ckluss at email.uni-kiel.de
Mon Jan 9 19:02:30 CET 2012


Hi

one col in my Excel file contains many numbers. But on line 3000 and
some other lines are strings like "FG 1". "RODBS" seems to omit this
lines. "gdata" works, but is much slower.

Is this a bug of RODBC or do I apply it wrong?

Example with the same "file.xlsx"


library(RODBC); excel <- odbcConnectExcel2007("file.xlsx")
tab <- sqlQuery(excel, 'select * from "Table 1$"'); str(tab)

col1: num  1 2 3 4 5 6 7 8 9 10 ...

library(gdata); tab <- read.xls("file.xlsx", sheet=1); str(tab)

col1: Factor w/ 51 levels "1","10","11",..: 1 12 23 34 41 42 43...


greeting
Christof



More information about the R-help mailing list