[R] A curious bug in read.xls

Abhijit Dasgupta adasgupt at mail.jci.tju.edu
Tue Jun 10 16:53:10 CEST 2008


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.
>



More information about the R-help mailing list