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 [EMAIL PROTECTED] 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? > > ______________________________________________ > [EMAIL PROTECTED] mailing list > https://stat.ethz.ch/mailman/listinfo/r-devel > > -- Brian D. Ripley, [EMAIL PROTECTED] 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 ______________________________________________ [EMAIL PROTECTED] mailing list https://stat.ethz.ch/mailman/listinfo/r-devel
