Folks,
Is there a parameter somewhere in RODBC that enables more columns to be
retrieved from an Excel worksheet?
# This next bit uses an undocumented call in RODBC
z <- odbcConnectExcel("./BBaselinePtQaires_apr2011.xls")
BQ <- sqlFetch(z, "BBaselinePtQaires")
Gives me:
z RODBC[1]
And
BQ 134 obs. of 59 variables
I have all the rows in the worksheet but only the first 59 out of a
total of 70 columns. I’m in RStudio 0.95.263 using RODBC 1.3-3 and R
version 2.12.2 (2011-02-25).
I'm puzzled - the worksheet seems ok. If the worst comes to the worst I
will have to split the worksheet and cbind to put it back together but
that seems inelegant. The worksheet contains 134 rows, 70 columns and is
in a spreadsheet that weighs in at 154 KB in total.
Can you help unbaffle me?
Andrew
______________________________________________
R-help@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.
