:[EMAIL PROTECTED] Behalf Of Christian Prinoth
Sent: 07 October 2008 11:29
To: R (D)COM and RExcel server related issues
Subject: [Rcom-l] Bug Report
Hi, the function ArrayFromSheet at a certain point uses the function Evaluate
to read in an array. The problem is, in certain cases the variable
Hi, the function ArrayFromSheet at a certain point uses the function
Evaluate to read in an array. The problem is, in certain cases the
variable ExcelDataRangeName may be so long that the whole string
cmdString gets longer than the maximum allowed (I think 255), which
means that the statement res =
There are a few objects in vba for handling addins. If you search for
"addin" in excel's vba help you will find all necessary details.
Basically, you should be able to do something like this:
For ai in Application.addins
if ai.name="RExcel" then found=true
Next ai
-Original Message---
rror messages saying:
Failed to Register:C:\Program
Files\RExcel\xls\RexcelFuncInfo.dll DummyFun02 RApplyC
And this happens for a few different functions. Is there the default
path hardcoded somewhere?
Thanks
Christian Prinoth
DISCLAIMER:
L'utilizzo non autorizzato del presente messa
into a VBA variable, you do not get a
string value, you get another data type!
Variant/Error
Christian Prinoth wrote:
> 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)
>
> Righ
l server related issues
Subject: Re: [Rcom-l] PutArrayFromVBA: numeric vs string
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 f
; a
[1] 1 2 3 0 5 6 7 0 9 10
What should I do to get
[1] 1 2 3 NA 5 6 7 NA 9 10
instead?
Thanks
Christian Prinoth
DISCLAIMER:
L'utilizzo non autorizzato del presente messaggio è vietato e potrebbe
costituire reato. Le informazioni e le opinioni contenute
BTW, the same applies to PutArrayFromVBA.
_
From: Christian Prinoth
Sent: Tuesday, April 15, 2008 18:14
To: 'rcom-l@mailman.csd.univie.ac.at'
Subject:PutArray
I am having problems with PutArray. After some debugging, I
will always work from now on.
Thanks
Christian Prinoth
DISCLAIMER:
L'utilizzo non autorizzato del presente messaggio è vietato e potrebbe
costituire reato. Le informazioni e le opinioni contenute in questo messaggio
sono inviate dal mittente a proprio nome e non costituiscono una posi
since the corresponding exception description is
ErrorRaise 1201, "RExcel.RInterface", "Invalid R variable name
in PutArray"
Shouldn't the test use IsLegalRName or something like this? Maybe a
typo?
Regards
Christian Prinoth
DISCLAIMER:
L'utilizzo non autori
BTW, the same applies to PutArrayFromVBA.
> _
> From: Christian Prinoth
> Sent: Tuesday, April 15, 2008 18:14
> To: 'rcom-l@mailman.csd.univie.ac.at'
> Subject: PutArray
>
> I am having problems with Pu
will always work from now on.
Thanks
Christian Prinoth
DISCLAIMER:
L'utilizzo non autorizzato del presente messaggio è vietato e potrebbe
costituire reato. Le informazioni e le opinioni contenute in questo messaggio
sono inviate dal mittente a proprio nome e non costituiscono una posi
since the corresponding exception description is
ErrorRaise 1201, "RExcel.RInterface", "Invalid R variable name
in PutArray"
Shouldn't the test use IsLegalRName or something like this? Maybe a
typo?
Regards
Christian Prinoth
DISCLAIMER:
L'utilizzo non autori
13 matches
Mail list logo