I found a curious bug in read.xls. I don't know if it's reproducible. It's like this: suppose I do a read.xls in a spreadsheet. A column begins with a number. Then, any strings below it will be rendered as NA. If the column begins with a string, then it will be rendered correctly. Alberto Monteiro
I believe read.xls has a colClasses argument. If you import using read.xls(filename, colClasses='character') everything will be imported as a string, and you can re-convert after importing Alberto Monteiro wrote:> I found a curious bug in read.xls. I don't know if it's reproducible. > > It's like this: suppose I do a read.xls in a spreadsheet. A column > begins with a number. Then, any strings below it will be rendered as NA. > If the column begins with a string, then it will be rendered correctly. > > Alberto Monteiro > > ______________________________________________ > 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. >
Alberto Monteiro wrote:> I found a curious bug in read.xls. I don't know if it's reproducible. > > It's like this: suppose I do a read.xls in a spreadsheet. A column > begins with a number. Then, any strings below it will be rendered as NA. > If the column begins with a string, then it will be rendered correctly. > > Alberto Monteiro > >Notice that this is in a contributed package (at least two of which have a read.xls...), not R as such. It would seem to be by design: The first value determines the variable type. You should be able to override this logic by using the colClasses argument. -- O__ ---- Peter Dalgaard ?ster Farimagsgade 5, Entr.B c/ /'_ --- Dept. of Biostatistics PO Box 2099, 1014 Cph. K (*) \(*) -- University of Copenhagen Denmark Ph: (+45) 35327918 ~~~~~~~~~~ - (p.dalgaard at biostat.ku.dk) FAX: (+45) 35327907