Regards,
Christian
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
] On Behalf Of Erich Neuwirth
Sent: Thursday, April 24, 2008 18:23
To: R (D)COM and RExcel server related issues
Subject: Re: [Rcom-l] PutArrayFromVBA: numeric vs string
This is an array with mixed
al Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth
Sent: Thursday, April 24, 2008 18:23
To: R (D)COM and RExcel server related issues
Subject: Re: [Rcom-l] PutArrayFromVBA: numeric vs string
This is an array with mixed data types.
This is difficult to h
ntains a Null value.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth
Sent: Thursday, April 24, 2008 17:22
To: R (D)COM and RExcel server related issues
Subject: Re: [Rcom-l] PutArrayFromVBA: numeric vs string
Handling missing values can b
& ")"
End If
End Sub
Which is not very elegant...
Btw, the function StringArray crashes if the array contains a Null value.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth
Sent: Thursday, April 24, 2008 17:22
To: R (D)COM and RExce
Handling missing values can be controlled when transferring
data from Excel sheets to R.
It is not implemented in detail when transferring
data from VBA to R.
Where does makearr come from anyway?
It is neither a VBA function vor a function from RExcel.
Christian Prinoth wrote:
I often use the
I often use the above function to trasfer arrays to R from VBA.
Sometimes these arrays have missing values, for example, I may have
a = makearr("1", 2, 3, "NA", 5, 6, 7, "#N/A", 9, 10)
If I do
putarrayfromvba "a", a
in R I get:
> a
[1] 1 2 3 0 5 6 7 0 9 10
