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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._