______________________________________________ R-help@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.
I can't tell since you didn't post any code, so forgive me if you've
tried this. XLConnect has a colTypes parameter so you could try
specifying the relevant columns to be read in as character, set
forceConversion = TRUE, and then use as.numeric. Something like this:
as.numeric(sub(",", ".", Input, fixed = TRUE)) from
http://stackoverflow.com/questions/15236440/as-numeric-with-comma-decimal-separators.
That will change the commas to dots and should eliminate the
conversion to NA problem you were having.
- Re: [R] XLConnect readWorksheet comma decimal sign Peter Keller
- Re: [R] XLConnect readWorksheet comma decimal sign Martin Studer