Re: [Rcom-l] rinterface RRun-RRunFile

://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277

Re: [Rcom-l] Error in R matlab connection

___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth

Re: [Rcom-l] RExcel.xla

Erich Neuwirth [EMAIL PROTECTED] ivie.ac.at

Re: [Rcom-l] VBA Code Issue

@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone

Re: [Rcom-l] Time Series Problem

@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http

Re: [Rcom-l] rcom comInvoke #2

I think you are misuntderstanding the rcom syntax. Try library(rcom) v-comCreateObject(comdll) i-comGetObjectInfo(v) str(i) # all ok I get function list # v$myfunction(PL,retval) # this is incorrenct snmtax # it depends what you want here. If myfunction is a methog of comddl # a d PL is a

Re: [Rcom-l] How to highlight R foreground in MS Excel

After installing rcom, you have to run the following two commands once. comRegisterRegistry() comRegisterServer() This is what the DOCUMENTATION TELLS YOU. Did you do that. After this is done, Set R Server should give you the option. If not, Click the Configure R server(s) button and follow the

Re: [Rcom-l] rcom comInvoke #2

@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http

Re: [Rcom-l] Macro RExcel help

Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: Wednesday, November 14, 2007 11:11 AM To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Macro RExcel help This is a VBA error. You are using double quotes within double quotes

Re: [Rcom-l] Resources for calling Excel from R

This is good advice, but one has to be careful. In VBA, some objects have default methods. Sub xxx() Dim x As Variant x = Range(A1) Debug.Print x End Sub will work, but the correct syntax is x = Range(A1).Value and you have to do the equivalent of this in you R code. I cannot

Re: [Rcom-l] Call rinterface.RRun(Source(ThisWorkbook.Path

___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty

Re: [Rcom-l] Put R valur into Execl Range

Use either string functions or the Cells property of the Range Yaning Zhang wrote: Hello, I could use some help here. Say I have got an R expression “num”, which is a single number. What I want to achieve is like following, including the “num” in the sheet range. Call

Re: [Rcom-l] Put R valur into Execl Range

- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: Wednesday, December 19, 2007 4:37 PM To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Put R valur into Execl Range Use either string functions or the Cells property of the Range Yaning

Re: [Rcom-l] Read Excel data

://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459

Re: [Rcom-l] Read Excel data

error. Regards, Uma -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: Tuesday, January 22, 2008 7:05 AM To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Read Excel data Uma

Re: [Rcom-l] RSrv200 and Excel 2007

We are currently completely overhauling the installation routines. The new package is called RAndFriendsxx, and it is available from rcom.univie.ac.at. The current versio is beta 10, but that one does not install R(D)COM, only rcom. If that is sufficient, please use it. RExcel has undergone

Re: [Rcom-l] RExcel Language

./ ___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer

Re: [Rcom-l] RExcel Language

in using put.dataframe in the French locale. You will see that there are no date fields present. Regards Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirth Sent: 07 April 2008 12:48 To: R (D)COM and RExcel server related issues Subject: Re

[Rcom-l] Crashes on nonEnglish Windows

Excel, CStr(True) produces Wahr, not True. Now we finally will be able to repair this nasty bug. Erich Neuwirth ___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including

Re: [Rcom-l] How to put/get data from/to autofiltered column?

-array and then use PutArrayFromVBA. However, I suspect this would be too easy with respect to data types, NAs? Any help welcome Kind regards Jens Oehlschlägel -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE

Re: [Rcom-l] RV: Description of Function

___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our

Re: [Rcom-l] RV: Description of Function

mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE

Re: [Rcom-l] Unable to change R Server Config

mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http

Re: [Rcom-l] Unable to change R Server Config

? 2) Ive tried searching for how to unregister the (D)COM server but with no luck. How do you do this? Regards Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirth Sent: 21 April 2008 17:58 To: R (D)COM and RExcel server related issues

Re: [Rcom-l] Unable to change R Server Config

appreciated. Regards Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirth Sent: 22 April 2008 08:50 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Unable to change R Server Config It is probably best to uninstall

[Rcom-l] New RAndFriends

I just uploaded RAndFriends including the new R 2.7.0 http://rcom.univie.ac.at/download/RAndFriendsSetup2070V20.exe -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277

Re: [Rcom-l] New RAndFriends

:[EMAIL PROTECTED] Behalf Of Erich Neuwirth Sent: 22 April 2008 15:07 To: R (D)COM and RExcel server related issues Subject: [Rcom-l] New RAndFriends I just uploaded RAndFriends including the new R 2.7.0 http://rcom.univie.ac.at/download/RAndFriendsSetup2070V20.exe -- Erich Neuwirth, University

Re: [Rcom-l] New RAndFriends

R(D)Com i.e.: Runtime Error (at 11:90) Internal Error. Cannot call ISCOMPENENTSELECTED function during uninstall. also happens on XP so this is not a vista issue. Regards Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirth Sent

Re: [Rcom-l] New RAndFriends

Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirth Sent: 24 April 2008 12:36 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] New RAndFriends Wayne, can you try using just running this installer http://rcom.univie.ac.at/download/devel

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

information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459

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

, 2) - LBound(arr, 2) + 1 ) 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

Re: [Rcom-l] Error message

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)))

[Rcom-l] Re: Error

. Let me know if you have any questions. Thanks --- Erich Neuwirth [EMAIL PROTECTED] wrote: Can you pack your files an either send them or put them in a place where I can download so I can reproduce the error? Felipe Carrillo wrote: Erich: I tried and I got the same Error messages four times

Re: [Rcom-l] New RAndFriends

. Regards Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirth Sent: 24 April 2008 12:36 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] New RAndFriends Wayne, can you try using just running this installer http

Re: [Rcom-l] R(D)COM

___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our

Re: [Rcom-l] Regarding ANOVA

___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty

Re: [Rcom-l] RExcel - foreground server

@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at

Re: [Rcom-l] RAndFriendsSetup2070V20-5 issues

(including a Wiki) at http://rcom.univie.ac.at ___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth

Re: [Rcom-l] RAndFriendsSetup2070V20-5 issues

://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ Rcom-l mailing list Rcom-l

Re: [Rcom-l] RAndFriendsSetup2070V20-5 issues

the corrected version. Please give me feedback if things now work. [EMAIL PROTECTED] wrote: Thanks Erich, This is very much appreciated. Looking forward to meeting you at UseR-2008. Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirth

Re: [Rcom-l] RAndFriendsSetup2070V20-5 issues

- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirth Sent: 30 May 2008 08:46 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] RAndFriendsSetup2070V20-5 issues Dear friends, and especially Wayne I just put up http://rcom.univie.ac.at/download/devel

Re: [Rcom-l] help

-- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ Rcom-l mailing list Rcom-l

Re: [Rcom-l] help

. This message was sent using IMP, the Internet Messaging Program. ___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich

[Rcom-l] RExcelInstaller_2.0-35

to prettyformat columns to display numbers with aligned decimal points. -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459

Re: [Rcom-l] Background RExcel

. ___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported

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

://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464

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

at the thought!)? You will have to check for yourself. Any thoughts on this would be appreciated. Note: As a small modification, I added the line Dim ai As AddIn to the code below so that does not give an error when Option Explicit is used. 'Function code by Erich Neuwirth [EMAIL PROTECTED

Re: [Rcom-l] RE: Problem in calling R in Excel

) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ Rcom-l mailing

Re: [Rcom-l] Problems in using RExcel

Please tell us version information abutt Windows, Excel, R and RExcel. On Aug 2, 2008, at 4:28 AM, Eric Fung wrote: Dear all, I am a newcomer and try to use RExcel after the installation. A number of errors are shown when running the demos. I find that the reasons behind are: All the

Re: [Rcom-l] RExcel with ESS

I've chosen is not a valid dataframe name. I should mention that these problems are relatively minor, and even if these problems aren't fixable, RExcel is still going to be incredibly useful for me; thanks so much for creating it. -- Scott On Sat, Aug 9, 2008 at 5:29 PM, Erich Neuwirth

[Rcom-l] Wikipedia

RExcel now has its own http://en.wikipedia.org/wiki/RExcel Please amend it if you think more information should be added. -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1

Re: [Rcom-l] PutDataFrame

Date: 10/9/2008 4:56 PM -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ Rcom-l mailing

Re: [Rcom-l] PutDataFrame

didn't get any items called Rexcel in my start programs and there is no Rexcel items in excel from the add-ins menu. FR 2008/10/13 Erich Neuwirth [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] The Start - Programs - R - RExcel

[Rcom-l] ROO (ROOo) Update

with this naming model, and the directory name will stay also. Therefore http://rcom.univie.ac.at/download/ROOo/ will always have the latest available version. -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http

Re: [Rcom-l] MISSING RCOM 1.0 Type Library

. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.2/1743 - Release Date: 10/24/2008 8:33 AM -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1

Re: [Rcom-l] MISSING RCOM 1.0 Type Library

installed (R, rcom, rscproxy, R/Scilab (D)COM Server,...) Thomas -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459

[Rcom-l] New versions

work depends on Hmisc, you should not yet upgrade or at least keep the old version around. -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459

Re: [Rcom-l] Problem installing RSrv250.exe

://rcom.univie.ac.at No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.4/1753 - Release Date: 10/28/2008 9:20 PM -- Erich Neuwirth, University

Re: [Rcom-l] status RExcel, rcom, rscproxy, R2.8.0: confused still

. What's going on here? No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.5/1755 - Release Date: 10/29/2008 5:27 PM -- Erich Neuwirth

Re: [Rcom-l] status RExcel, rcom, rscproxy, R2.8.0: confused still

. Is it OK to comment out those lines temporarily from Rprofile.site in order do the package update? Starting R with the command line RGui --vanilla starts R without reading Rprofile.site, then you can safely update everything. -- Erich Neuwirth, University of Vienna Faculty of Computer Science

Re: [Rcom-l] status RExcel, rcom, rscproxy, R2.8.0: confused still

something fixed? Erich Neuwirth wrote: Check if your server is set to foreground server in Excel: RExcel - Set R server In this dialog box you also can check if you can connect to the foreground (rcom) or background ((D)COM) server. The foreground server does not need the (D)COM server. It needs

Re: [Rcom-l] status RExcel, rcom, rscproxy, R2.8.0: confused still

, as I recall, RExcel used to be bundled in with the (D)COM server's installer. Erich Neuwirth wrote: (D)COM server 2.5.0 does not work with R 2.8.0 because the inner workings of R have been changed. We already have a beta version of (D)COM server 3.0 working with R 2.8.0, and Thomas already

Re: [Rcom-l] R Graphics

@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth Didactic Center for Computer Science and Institute for Scientific Computing University of Vienna ___ Rcom

Re: [Rcom-l] Background server doesn't work

://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ Rcom-l mailing list

Re: [Rcom-l] Advice on using .NET with R(COM)

@mailman.csd.univie.ac.at http://mailman.csd.univie.ac.at/mailman/listinfo/rcom-l More information (including a Wiki) at http://rcom.univie.ac.at -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1

Re: [Rcom-l] Advice on using .NET with R(COM)

? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: Tuesday, December 02, 2008 3:17 PM To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Advice on using .NET with R(COM) Can you please give us the source code, or can you put

[Rcom-l] Installation

. -- Erich Neuwirth, University of Vienna Faculty of Computer Science Computer Supported Didactics Working Group Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ Rcom-l mailing list Rcom-l

Re: [Rcom-l] R (D)COM Server

the error messages described below. Original-Nachricht Datum: Tue, 02 Dec 2008 15:05:51 +0100 Von: Erich Neuwirth [EMAIL PROTECTED] An: R (D)COM and RExcel server related issues rcom-l@mailman.csd.univie.ac.at Betreff: Re: [Rcom-l] R (D)COM Server Do you have a full