[R] A curious bug in read.xls
P.Dalgaard at biostat.ku.dk
Tue Jun 10 17:03:29 CEST 2008
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
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
More information about the R-help