Hi,
XLConnect can very well deal with missing values. By default, only
blank cells (cells not containing any values) will be treated as
missing values. Cells containing the text "NA" are not automatically
treated as missing values as "NA" is a valid non-missing text string.
If you want to treat th
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(",", ".", I
Am 02.12.2013 21:28, schrieb David Winsemius:
In fact you can set that globally with: ?options
options()$OutDec # my setting
[1] "."
Oh sorry I thought you mentioned to set excel globally to dot.
no change when setting it to dot. I seems that XLConnect is not able to
deal with NA in Excel,
On Dec 2, 2013, at 1:17 AM, Knut Krueger wrote:
> Am 29.11.2013 20:39, schrieb David Winsemius:
>>> Thats impossible, we are used to hit the comma
>> I don't know what that means.
> it is common here, that the decimal sign is commy
Believe me, I _do_ understand that in Europe it is common to use
Am 29.11.2013 20:39, schrieb David Winsemius:
Thats impossible, we are used to hit the comma
I don't know what that means.
it is common here, that the decimal sign is commy
All computer in the cip-pools are using the "comma" ( an I think 99.9%
of all other computers here)
Can you imagine what
On Nov 29, 2013, at 10:30 AM, Knut Krueger wrote:
> Am 29.11.2013 18:31, schrieb David Winsemius:
>> On Nov 29, 2013, at 6:18 AM, Knut Krueger wrote:
>>
>>> 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 dat
Please understand that this is a contributed package, and definitive assistance
can only be provided by the package author. Type
maintainer("XLConnect")
for contact information, and read the package info at
cran.r-project.org/web/packages/XLConnect/index.html. R-devel is unlikely to be
a more
Am 29.11.2013 18:31, schrieb David Winsemius:
On Nov 29, 2013, at 6:18 AM, Knut Krueger wrote:
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 c
On Nov 29, 2013, at 6:18 AM, Knut Krueger wrote:
> 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 h
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 impossibl
Am 25.11.2013 11:29, schrieb PIKAL Petr:
Hi
Either change comma to dot in Excel (but sometimes Excel is rather reluctant to
accept such changes).
Or change commaa to dot in R which probably can be easily done by gsub command
Or read data with option dec=",". I do not know XLConnect but in rea
ameter and maybe it is also readWorksheet.
Regards
Petr
> -Original Message-
> From: r-help-boun...@r-project.org [mailto:r-help-bounces@r-
> project.org] On Behalf Of Knut Krueger
> Sent: Monday, November 25, 2013 10:11 AM
> To: r-h...@stat.math.ethz.ch
> Subject: [R] X
Hi to all,
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
Kind Regards Knut
__
R-help@r-project.org mailing list
https://stat.e
13 matches
Mail list logo
