[R] Re: r-excel interface code

[Amy C. Peng]

I am using the R-Excel interface, which is in Contributed Extensions /
Nonstandard Extensions on CRAN.

It seems that all #N/A values in Excel are being transferred over to R as
0's.  Also, when I transfer data from R back to Excel, NA values in R show
up as 1.#QNAN in Excel if I use the RGet function, and they show up as
65535 if I use the GetArray function.  (RGet and GetArray are functions of
the Excel AddIn.)

Is there any way to preserve NA values using the R-Excel interface, without
explicitly coding NA's as integers, say -9999999, transfering the data
between Excel and R, and then recoding the value -9999999 as the
appropriate missing value representation (i.e., #N/A in Excel, and NA in R)?

I was just wondering if anybody has any experience with this?  Thanks a lot
for your comments!

  -Amy Peng


At 01:26 PM 2/25/2000 +0100, you wrote:
>
>some of you might be interested.
>
>i just uploaded the first release of my 
>r-excel interface package to CRAN.
>
>it is in
>contributed extensions
>nonstandard extensions
>
>erich neuwirth
>
>--
>Erich Neuwirth, Computer Supported Didactics Working Group
>Visit our SunSITE at http://sunsite.univie.ac.at
>Phone: +43-1-4277-38624 Fax: +43-1-4277-9386
>
>-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
.-.-
>r-announce mailing list -- Read
http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
>Send "info", "help", or "[un]subscribe"
>(in the "body", not the subject !)  To: r-announce-request at stat.math.ethz.ch
>_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
._._
>
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._