[R] XLConnect readWorksheet comma decimal sign

Knut Krueger rh at knut-krueger.de
Tue Dec 3 14:38:06 CET 2013


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, means its string instead an number after importing.

>
>   If you continue having difficulty using XLConnect, then you should contact the authors of that package.
I tried - no answer yet.

Thank you Knut



More information about the R-help mailing list