Do read the FAQ and stop abusing R-bugs in this way. I did ask privately, but you have continued to ignore my request. BDR
On Tue, 9 Nov 2004 bgunter@gene.com wrote:
Full_Name: Bert Gunter Version: 2.0.0 patched OS: Win2000 Submission from: (NULL) (192.12.78.250) The TRUE/FALSE options of the colnames argument in sqlFetch (RODBC) seem to be reversed, at least for .xls files. ## z is a connection to an xls workbook opened by odbcConnectExcel()
dat<-sqlFetch(z,'SuccessRates',colnames=FALSE) dat[1:5,]
RecID Name Run Grams Lost Run (80L) 1 NA Activase 117 839.91 0 2 NA Activase 118 860.52 0 3 NA Activase 119 921.23 0 4 NA Activase NA NA 1 5 NA Activase 120 722.62 0
dat2<-sqlFetch(z,'SuccessRates',colnames=TRUE) dat2[1:5,]
NA Activase 117 839.91 0 2 NA Activase 118 860.52 0 3 NA Activase 119 921.23 0 4 NA Activase NA NA 1 5 NA Activase 120 722.62 0 6 NA Activase 121 762.48 0 I note also that the last column, "Lost Run (80L)," was actually TRUE/FALSE and some blanks in the Excel sheet and was silently coerced to numeric. This is no problem, of course, but I wonder if it's the intended behavior and, if so, is it documented?
______________________________________________ R-devel@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
Brian D. Ripley, ripley@stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK Fax: +44 1865 272595