[R] RODBC vs gdata

Enrico Schumann enricoschumann at yahoo.de
Mon Jan 9 19:29:29 CET 2012


Hi Christof,

have a look at the manual of RODBC, and in particular the section on 
Excel drivers.

RShowDoc("RODBC", package="RODBC")

Regards,
Enrico


Am 09.01.2012 19:02, schrieb Christof Kluß:
> 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
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

-- 
Enrico Schumann
Lucerne, Switzerland
http://nmof.net/



More information about the R-help mailing list