RE: [Rcom-l] Bug Report

2008-10-07 Thread Christian Prinoth
:[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

[Rcom-l] Bug Report

2008-10-07 Thread Christian Prinoth
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 =

RE: [Rcom-l] Detecting if RExcel is installed

2008-07-17 Thread Christian Prinoth
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---

[Rcom-l] Problem with RAndFriends

2008-06-20 Thread Christian Prinoth
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

RE: [Rcom-l] PutArrayFromVBA: numeric vs string

2008-04-28 Thread Christian Prinoth
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

RE: [Rcom-l] PutArrayFromVBA: numeric vs string

2008-04-24 Thread Christian Prinoth
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

[Rcom-l] PutArrayFromVBA: numeric vs string

2008-04-24 Thread Christian Prinoth
; 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

[Rcom-l] RE: PutArray

2008-04-16 Thread Christian Prinoth
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

[Rcom-l] GetArrayToVBA

2008-04-16 Thread Christian Prinoth
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

[Rcom-l] PutArray

2008-04-16 Thread Christian Prinoth
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

[Rcom-l] RE: PutArray

2008-04-16 Thread Christian Prinoth
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

[Rcom-l] GetArrayToVBA

2008-04-15 Thread Christian Prinoth
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

[Rcom-l] PutArray

2008-04-15 Thread Christian Prinoth
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