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,
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(,, .,
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 the
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 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 a
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
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 here is a major
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
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
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 data as ascii and
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 read.table it
is optional parameter and maybe
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
12 matches
Mail list logo