Message-ID: <5298A218.2090303@knut-krueger.de>
Date: 2013-11-29T14:18:00Z
From: Knut Krueger
Subject: XLConnect readWorksheet comma decimal sign
In-Reply-To: <52933D4B.90803@knut-krueger.de>
Am 25.11.2013 13:06, schrieb Knut Krueger:
>
>> how can I read exel files where the decimal sign is comma instead dot.
>> I get the data as ascii and when converting "3,5" with as.numeric
>> the 3,5 will be converted to NA
>
I think here is a major bug because no warning is genereated.
It is impossible to change excel to dot decimal separator.
First reason it is unusual in our (and I think also other countries).
Lot of computers in the university are using decimal separator mostly
without R. The user would be unable (or simply do not want) to use it
furthermore.
A question
does anybody know whether Rcmdr and XLConnect are using the same or
different ways to import Excel?
We found also that RCmdr is setting comma separated values to na if
there is an NA in the column.
Maybe it more useful to discuss this in the devel group? (set the
follow up to DEVEL)
Knut