[R] A curious bug in read.xls

Peter Dalgaard 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 mailing list