Wayne,
can you try using just running this installer
http://rcom.univie.ac.at/download/devel/RSrv250_pl2.exe
and see if you get the problems.
Then we know a little better where to locate the issues.
Erich
[EMAIL PROTECTED] wrote:
Hi Erich and fellow rcom users,
I have been doing some
The xls files in
RSrv250_pl2
are quite outdated. RAndFriends suppresses installation of these files.
Please remove the xls directory in the (D)COM directory
and then install RExcelInstaller from CRAN and run
RExcelInstall.
Or just run RAndFriends again after removing the xls directory under
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
What
Try this one.
It should solve both problems.
http://rcom.univie.ac.at/download/devel/DCOMNoExcel.exe
[EMAIL PROTECTED] wrote:
Hi Erich,
I installed RSrv250_pl2 and got the same error message as before, namely:
C\Windows\System32\stdole2.tlb
Unable to register the type library:
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
Sorry, that's just one of my concoctions, just replace it with
a = array(1, 2, 3, NA, 5, 6, 7, #N/A, 9, 10)
Right now I do this:
Sub NumArr2R(VarName As String, arr)
Dim n As Integer, i As Integer
n = ismatrix(arr)
If n = 0 Then
arr = CStr(arr)
ElseIf n = 1 Then
This is an array with mixed data types.
This is difficult to handle.
I do a lot of analyzing for missing values in Excel sheets,
but I cannot do that in VBA easily.
What you are doing is not using missing values,
but string values as placeholders for missing values.
The next release (which is
Hi: I am getting the following message with the new
RExcel Version (RExcelInstaller)
Error-2147220502
In Module RExcel.RServer
Error running expression
eval(parse(text=close(rexcel..ahxirwf)))
Everything was working fine with the older version
Rsrv250_p|1.exe. I am transferring 52 weeks of data
What code are you using to read the files?
On Apr 24, 2008, at 9:09 PM, Felipe Carrillo wrote:
Hi: I am getting the following message with the new
RExcel Version (RExcelInstaller)
Error-2147220502
In Module RExcel.RServer
Error running expression
eval(parse(text=close(rexcel..ahxirwf)))