[Rcom-l] Installation
There were quite a few messages recently about the installation process of R, RExcel, rcom The wiki on the rcom web site at http://rcom.univie.ac.at has a section Installation of R, R(D)COM server and RExcel with instructions for the initial installation of all the needed compontents. -- 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@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
Re: [Rcom-l] R (D)COM Server
During installation you have the options of standard or complete install. Christoph Hamer wrote: Thank you for your fast reply My Excel edition came with MS Office Professional Edition 2003 so i guess its a full installation. If i start Excel there is no RExcel button but i get 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 installation of Excel or only a standard installation? When you start Excel now, do you get the RExcel menu? If yes, got into RExcel - About and click copy to clipboard and then paste the clipboard content in an email you send to the list. Christoph Hamer wrote: Hi I did as recommended: - download R 2.8.0 - download and execute http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe - install Rexcel from R If i try to open rexcel it dies and I get strange error messages (sorry its german): Kompilierungsfehler in verborgenem Modul ThisWorkbook Afterwards the Programm tells me: RExcel is now configured for Excel 2003 Fehler beim Kompilieren die Objektbibliothek ist ungültig oder enthällt Verweise Objektdefinitionen, die nicht gefunen werden konnten. I am a puzzeled since i just followed the instructions below. What or where did I mess up? Cheers Christoph Original-Nachricht Datum: Mon, 01 Dec 2008 21:14:29 +0100 Von: Thomas Baier [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 Christoph Hamer schrieb: Hi, i am interested in using R, Rexcel and an extra insurance package (either reserving or Chainladder). Unfortunately I was not able to find the exe of the compulsory R (D)COM Server. The only thing i can find is a not working link to http://rcom.univie.ac.at/download/RAndFriends.distro/RAndFriendsSetup2072V3.0-3.exe on http://learnserver.csd.univie.ac.at/rcomwiki/doku.php?id=rexcel_as_an_r_package R is so cool and would be so much more powerfull if i coult use it with Excel together. Try http://rcom.univie.ac.at/download/current/R_Scilab_DCOM3.0-1B5.exe and install the package RExcelInstaller from within R. Thomas ___ 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 No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.9.12/1823 - Release Date: 12/1/2008 7:59 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 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 No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.176 / Virus Database: 270.9.12/1823 - Release Date: 12/1/2008 7:59 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 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
Re: [Rcom-l] Background server doesn't work
You are right. With R 2.8.0 you need the new (D)COM server, available from CRAN in (or your favorite CRAN site). http://cran.at.r-project.org/contrib/extra/dcom/ Please have a look at the license, it has changes and is not GPL or LGPL any more. Felipe Carrillo wrote: I am trying to run it from an excel macro. R runs fine and executes the script on foreground but if I switch to background then R isn't available. I get the message error saying There seems to be no R process connected to Excel. I didn't have any problems to run R on foreground with the old version of RSrv250_pl1.exe but this old version doesn't seem to work with R 2.8. --- On Mon, 12/1/08, Thomas Baier [EMAIL PROTECTED] wrote: From: Thomas Baier [EMAIL PROTECTED] Subject: Re: [Rcom-l] Background server doesn't work To: [EMAIL PROTECTED], R (D)COM and RExcel server related issues rcom-l@mailman.csd.univie.ac.at Date: Monday, December 1, 2008, 12:53 PM Felipe, Felipe Carrillo schrieb: Hi: I just downloaded the new version R_Scilab_DCOM3.0-1B5.exe and followed the instructions: After installation of Scilab, and R/Scilab (D)COM Server, please copy sciproxy.dll from the Scilab folder of the R/Scilab (D)COM Server installation directory to the bin folder of the Scilab installation directory. But R keeps poping up on the forground. I do have the rcom package. the rcom packages gets loaded when R starts. Any hints? Please clarify what you mean with R keeps popping up on the foreground. Which application did you start that uses R (foreground)? Thomas ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] Advice on using .NET with R(COM)
Can you please give us the source code, or can you put it in our Wiki at rcom.univie.ac.at? Biresh Giri wrote: Qiao I would like to see the source code as well. Could you please forward to [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Thanks Biresh On Tue, Dec 2, 2008 at 6:43 AM, Qiao Hui-jie [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: hi Alex: I have made a project written by c#. It can run R in a winform. I have mapped most of the basic objects in R to c# objects. May be it a valuable project for you. It's pity that a have no enought time to finish it. But i can provide all the source code to you. Give me an email address if you want this. Best regards Qiao Huijie Institute of Zoology, Chinese Academy of Sciences 2008-12-2 -Original Message- From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]] On Behalf Of Alex Park Sent: Monday, December 01, 2008 1:59 AM To: rcom-l@mailman.csd.univie.ac.at mailto:rcom-l@mailman.csd.univie.ac.at Subject: [Rcom-l] Advice on using .NET with R(COM) Hello I would like to get some simple advice on building a .NET application that uses R for statistical calculations and displays charts using R graphical packages. Please understand that I am a neophyte programmer and maybe behind the curve on a number of programming issues... I am most familiar with Visual Basic and my intention is to make a desktop application. I have a lot of time series data (financial market data) and my intention is to place it all in a database and use ADO.Net to retrieve data and then manipulate in R (stats, create data tables, produce charts) and then display in my VB.NET http://vb.net/ application front end. As an example, I may want my application to be able to display the % return of all global equity markets in the past week, and to show this as a data table that is accompanied by a simple bar chart that is sorted by best performing index first. Before I start writing any code for this I had a handful of questions: 1) Is using Visual Basic the best choice or are there significant advantages of using C# or C++ within .NET? For example, are there performance advantages of using C++ over VB when it comes to processing large amounts of data, and especially if there are lots of loops involved etc? What do people think? 2) In my mind, I was thinking that I could place my data in the database that comes with .NET, use ADO to retrieve the data I required, and then pass this to R to get the desired output. I am wondering though whether it would be better to build lots or routines in R and let them call the data from the directly from the database i.e. I just use VB front end to execute pre-configured routine in R which will automatically use SQL functionality to retrieve the required data? Again, any thoughts on this? 3) I have managed to poke around the internet (R.org, Nabble etc.) and have managed to get together some introductory papers on using R(COM) with .NET. Is there an 'official' guide that I am missing or can anybody point to any useful sources that might help me get started? I appreciate any time anybody can spare to give me some help. Before I get started I want to avoid going down a blind alley and am more than prepared to have to upskill significantly (e.g. gain a better grasp of C++) if that will give enable me to build much better applications in terms of functionality and performance. I just want some advice before I invest in some books and get cracking. Thanks again Alex ___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at mailto: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 http://rcom.univie.ac.at/ ___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at mailto: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 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, University of Vienna Faculty of Computer Science
Re: [Rcom-l] Advice on using .NET with R(COM)
Can you export it to an ASCII file and send it to me? Then I will try to put it into the Wiki. I will mark it as unfinished. Qiao Hui-jie wrote: I'd like to do this. But the code is an unfinished version. And I have no time to finish it recently. How to give you the code? -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 it in our Wiki at rcom.univie.ac.at? Biresh Giri wrote: Qiao I would like to see the source code as well. Could you please forward to [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Thanks Biresh On Tue, Dec 2, 2008 at 6:43 AM, Qiao Hui-jie [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: hi Alex: I have made a project written by c#. It can run R in a winform. I have mapped most of the basic objects in R to c# objects. May be it a valuable project for you. It's pity that a have no enought time to finish it. But i can provide all the source code to you. Give me an email address if you want this. Best regards Qiao Huijie Institute of Zoology, Chinese Academy of Sciences 2008-12-2 -Original Message- From: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]] On Behalf Of Alex Park Sent: Monday, December 01, 2008 1:59 AM To: rcom-l@mailman.csd.univie.ac.at mailto:rcom-l@mailman.csd.univie.ac.at Subject: [Rcom-l] Advice on using .NET with R(COM) Hello I would like to get some simple advice on building a .NET application that uses R for statistical calculations and displays charts using R graphical packages. Please understand that I am a neophyte programmer and maybe behind the curve on a number of programming issues... I am most familiar with Visual Basic and my intention is to make a desktop application. I have a lot of time series data (financial market data) and my intention is to place it all in a database and use ADO.Net to retrieve data and then manipulate in R (stats, create data tables, produce charts) and then display in my VB.NET http://vb.net/ application front end. As an example, I may want my application to be able to display the % return of all global equity markets in the past week, and to show this as a data table that is accompanied by a simple bar chart that is sorted by best performing index first. Before I start writing any code for this I had a handful of questions: 1) Is using Visual Basic the best choice or are there significant advantages of using C# or C++ within .NET? For example, are there performance advantages of using C++ over VB when it comes to processing large amounts of data, and especially if there are lots of loops involved etc? What do people think? 2) In my mind, I was thinking that I could place my data in the database that comes with .NET, use ADO to retrieve the data I required, and then pass this to R to get the desired output. I am wondering though whether it would be better to build lots or routines in R and let them call the data from the directly from the database i.e. I just use VB front end to execute pre-configured routine in R which will automatically use SQL functionality to retrieve the required data? Again, any thoughts on this? 3) I have managed to poke around the internet (R.org, Nabble etc.) and have managed to get together some introductory papers on using R(COM) with .NET. Is there an 'official' guide that I am missing or can anybody point to any useful sources that might help me get started? I appreciate any time anybody can spare to give me some help. Before I get started I want to avoid going down a blind alley and am more than prepared to have to upskill significantly (e.g. gain a better grasp of C++) if that will give enable me to build much better applications in terms of functionality and performance. I just want some advice before I invest in some books and get cracking. Thanks again Alex ___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at mailto: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 http://rcom.univie.ac.at/ ___ Rcom-l mailing list Rcom-l@mailman.csd.univie.ac.at mailto:Rcom-l@mailman.csd.univie.ac.at http
Re: [Rcom-l] R Graphics
The latest version of RExcel has Insert current R plot on the context menu. This is only available if an R plor exists, of course. You can check the source code to see how it is implemented. It does some trickery about colors and frames. On Nov 18, 2008, at 1:16 PM, Vilmos Prokaj wrote: Hi, I dont know wether this the good solution for you or not, but for your last idea I thought of using a image control instead of the StatConnectorGraphicsDevice control. Dim sconn As StatConnector Set sconn = New StatConnector sconn.Init R * sconn.EvaluateNoReturn windows(4,4)* sconn.EvaluateNoReturn plot(sin(1:10)) *conn.EvaluateNoReturn savePlot(file=, type = wmf)* sconn.Close *IN VB** *Image1.Picture = Clipboard.GetData(vbCFMetafile)* the following can help. There is a win.metafile device in R which writes directly to file (or clipboard if filename is ) so your code should be like this sconn.EvaluateNoReturn win.metafile(,4,4) sconn.EvaluateNoReturn plot(sin(1:10)) sconn.EvaluateNoReturn dev.off() and finally Image1.Picture = Clipboard.GetData(vbCFMetafile) I did not test this last line. I used Ctrl-V on an Excel worksheet, and it worked, so the image is copied to the clipboard by the above method. -- Vilmos Prokaj Eötvös Loránd University, Department of Probability and Statistics Pázmány Péter sétány 1/C Budapest, 1117 Hungary e-mail:[EMAIL PROTECTED] ___ 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 Didactic Center for Computer Science and Institute for Scientific Computing University of Vienna ___ 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
Re: [Rcom-l] status RExcel, rcom, rscproxy, R2.8.0: confused still
Did you do an uninstall of the previous version of the (D)COM server? Your problem should not have happened if you had uninstalled. Were your servers configured as typed or as untyped? RExcelInstaller now installs RExcel in Program Files\RExcel One of the reasons is that it can even be used without R on the same machine, and putting it in a subdirectory of R_HOME would not make sense in that scenario. Murray Eisenberg wrote: I had downloaded (D)COM server 3.0 beta and installed it several days ago. But I just discovered why, even with that, why things were not working: It was the path to (D)COM! I had to execute the RExcel Set R Server Configure R server(s) command and enter the path to (D)Com there. I don't think I had seen anywhere that by default (D)COM was supposed to be at ..\(D)COM Server\ relative to RExcel.xla. I had installed (D)COM to one subdirectory of my main R directory (of which R-2.8.0 is a subdirectory, too) and RExcel to another subdirectory of that directory. I thought that was a sensible layout where I could neatly keep the two distributions, (D)COM and RExcel, separate from one another. I guess I had not encountered this before because, 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 posted to the list where to get it. Murray Eisenberg wrote: The setting for the Excel R Server was Background. When I set it to Foreground, I could indeed start R from the Check Server button in the R Server dialog. So what is the role of (D)COM to be? Do I have to wait until some one or more of the various components -- (D)COM itself, rscproxy, rcom, RExcel, perhaps even base R -- gets 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 rcom and rscproxy. A minimalistic version of getting something that works is Unistall any previous version of the (D)COM server from the control panel. Install R Install the packages rscproxy, rcom, and RExcelInstaller then run the following commands library(rcom) comRegisterRegistry() library(RExcelInstaller) installRExcel() After that, RExcel should work. Prokaj Vilmos wrote: The latest rscproxy is 1.0-12. 1.0-11 is buggy. Wait for the compiled binary or compile yourself from sources. I could download this morning the source of the new version from the austrian mirror of CRAN. Murray Eisenberg írta: I have R 2.8.0. In its library I have the latest rcom (2.0.4) and rscproxy (1.0.11) from CRAN (as of 15 minutes ago). I installed the latest RExcelInstaller (3.0.5), and I still have the recently installed DCOM from R_Scilab_DCOM3.0-1B1beta.exe When I start R it tells me that rcom and rscproxy are required packages that have been loaded. Just to make sure, I executed: library(rcom) comRegisterRegistry() Still, when I I try Server 01- Basic Test, I get a pop-up StatConnector Test window. If I click the Start R button, I see: Loading StatConnector Server... Done Initializing R...Function call failed Code: -2147221485 Text: installation problem: unable to load connector and I get a separate Test1 pop-up saying Method '~' of object '~' failed. And still if, from Excel's RExcel menu item I select R Start, I get a pop-up saying: Could not start RServer. 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 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 No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.175 / Virus Database: 270.8.5/1757 - Release Date: 10/30/2008 2:35 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 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
Re: [Rcom-l] Problem installing RSrv250.exe
If you also install rcom and then run library(rcom) comRegisterRegistry() that should solve your problem. The reason is that RSrv250 installs an outdated version of RExcel which has this problem. The package RExcelInstaller on CRAN installs the latest version of RExcel which does not have this problem either. Hanák Gábor wrote: Sorry, Greg, It is reporting the same problem. What I did was: 1. I completely removed R 2.8.0 2. I completely removed R/Scilab (D)Com Server 2.50 and RExcel 1.75 3. I installed R 2.7.2 (it was fine) 4. I installed R/Scilab (D)Com Server 2.50 and RExcel 1.75 Unfortunately upon completion of task 4, I experienced exactly the same error (stopping execution of the VBA program with the LEFT function being the problem). Shall I go back to even older version of R? Which one? Gabor -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg James Sent: 2008. október 29. 15:59 To: 'R (D)COM and RExcel server related issues' Subject: RE: [Rcom-l] Problem installing RSrv250.exe Gabor, RDCom is not currently compatible with R-2.8.0. I had the same problem and found that R-2.8.0 no longer installs an rproxy.dll file which is what RDCom is programmed to look for. There is no workaround right now except dropping back to R-2.7.2 which is what I've done. The VBA error message is due to Application.Version sending an illegal value to the left function. -Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Hanák Gábor Sent: Wednesday, October 29, 2008 7:08 AM To: rcom-l@mailman.csd.univie.ac.at Subject: [Rcom-l] Problem installing RSrv250.exe Can anybody help me with the following installation probelm? I use Windows XP Professional Version 5.1 (SP3) I use Microsoft Office Excel 2003 SP3 I successfully installed R 2.8.0 When I wanted to install RSrv250 it went smothly for a while and after I got a message saying Completing the R/Scilab (D)Com Server and RExcel Setup Wizard, I pushed the Finish button. Then the program started Microsoft Visual Basic and in the file RExcel.xla, in the project RExcelVBAlib, in the module MenuTools, in the function ExcelVersionMajor() a compile error was reported saying: Can't find project or library and the in the statement ExcelVersionMajor = CInt(Left(Application.Version, pos - 1)) the function Left was highlighted. I do not understand why the Left function was not found, if I go to the Object Browser then I can find Left as Function Left(String, Length As Long). As a result, after stopping the execution of the Visual Basic program and starting Excel, the same error message is generated. Then I can only use Excel properly if I uncheck RExcel in the Add-ins dialog. If I check RExcel, the same thing happens. Thus it seems I can not use RExcel at all. Thanks for any help Gabor ___ 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 ___ 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 ___ 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 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 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@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
Re: [Rcom-l] status RExcel, rcom, rscproxy, R2.8.0: confused still
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 rcom and rscproxy. A minimalistic version of getting something that works is Unistall any previous version of the (D)COM server from the control panel. Install R Install the packages rscproxy, rcom, and RExcelInstaller then run the following commands library(rcom) comRegisterRegistry() library(RExcelInstaller) installRExcel() After that, RExcel should work. Prokaj Vilmos wrote: The latest rscproxy is 1.0-12. 1.0-11 is buggy. Wait for the compiled binary or compile yourself from sources. I could download this morning the source of the new version from the austrian mirror of CRAN. Murray Eisenberg írta: I have R 2.8.0. In its library I have the latest rcom (2.0.4) and rscproxy (1.0.11) from CRAN (as of 15 minutes ago). I installed the latest RExcelInstaller (3.0.5), and I still have the recently installed DCOM from R_Scilab_DCOM3.0-1B1beta.exe When I start R it tells me that rcom and rscproxy are required packages that have been loaded. Just to make sure, I executed: library(rcom) comRegisterRegistry() Still, when I I try Server 01- Basic Test, I get a pop-up StatConnector Test window. If I click the Start R button, I see: Loading StatConnector Server... Done Initializing R...Function call failed Code: -2147221485 Text: installation problem: unable to load connector and I get a separate Test1 pop-up saying Method '~' of object '~' failed. And still if, from Excel's RExcel menu item I select R Start, I get a pop-up saying: Could not start RServer. 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, 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@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
Re: [Rcom-l] status RExcel, rcom, rscproxy, R2.8.0: confused still
Murray Eisenberg wrote: Thanks for that information; I sure hope this cures the troubles. Question: Off-topic, but intimately related... Rprofile.site, in the R 2.8.0 etc directory, includes the lines: library(utils) if (.Platform$GUI %in% c(Rgui,Rterm)){ if(!(rcom %in% installed.packages()[, Package])){ install.packages(rcom, dep = T); require(rcom); dummy-comRegisterRegistry()} else { require(rcom)}} I'm not sure whether they were already there in the version of Rprofile.site that came with the 2.8.0 distribution or whether I put them there because I had them there in for an earlier version of R. These lines are put there by the RExcelInstaller. But obviously they block doing package update of rcom, and hence of rscroxy, from within Rgui, since these packages are already loaded when the R command line becomes available within Rgui. 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 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@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
Re: [Rcom-l] status RExcel, rcom, rscproxy, R2.8.0: confused still
(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 posted to the list where to get it. Murray Eisenberg wrote: The setting for the Excel R Server was Background. When I set it to Foreground, I could indeed start R from the Check Server button in the R Server dialog. So what is the role of (D)COM to be? Do I have to wait until some one or more of the various components -- (D)COM itself, rscproxy, rcom, RExcel, perhaps even base R -- gets 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 rcom and rscproxy. A minimalistic version of getting something that works is Unistall any previous version of the (D)COM server from the control panel. Install R Install the packages rscproxy, rcom, and RExcelInstaller then run the following commands library(rcom) comRegisterRegistry() library(RExcelInstaller) installRExcel() After that, RExcel should work. Prokaj Vilmos wrote: The latest rscproxy is 1.0-12. 1.0-11 is buggy. Wait for the compiled binary or compile yourself from sources. I could download this morning the source of the new version from the austrian mirror of CRAN. Murray Eisenberg írta: I have R 2.8.0. In its library I have the latest rcom (2.0.4) and rscproxy (1.0.11) from CRAN (as of 15 minutes ago). I installed the latest RExcelInstaller (3.0.5), and I still have the recently installed DCOM from R_Scilab_DCOM3.0-1B1beta.exe When I start R it tells me that rcom and rscproxy are required packages that have been loaded. Just to make sure, I executed: library(rcom) comRegisterRegistry() Still, when I I try Server 01- Basic Test, I get a pop-up StatConnector Test window. If I click the Start R button, I see: Loading StatConnector Server... Done Initializing R...Function call failed Code: -2147221485 Text: installation problem: unable to load connector and I get a separate Test1 pop-up saying Method '~' of object '~' failed. And still if, from Excel's RExcel menu item I select R Start, I get a pop-up saying: Could not start RServer. 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 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, 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@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
[Rcom-l] New versions
There is a new version of RExcelInstaller on CRAN, and it installs a slightly improved version of RExcel. The installer now checks of rcom is available and gives appropriate warnings if not. There also is a new version of RAndFriendsLight on the rcom web site. It already includes R 2.8.0. The full version of RAndFriends is not available yet. The (D)COM server needs a major overhaul for R 2.8.0 and this is currently in the beta phase (as Thomas told you in an earlier posting). One additional warning: RAndFriends included the package Hmisc. This is not available yet for R 2.8.0. So if your 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 ___ 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
Re: [Rcom-l] MISSING RCOM 1.0 Type Library
Murray, you probably had R-2.4.1 installed on this machine at the given location and did not update fully. The package rcom creates a registry entry. This is done when you run the command comRegisterRegistry() at first use. When you install a new version of R, you need to install the latest version of rcom and run this command again. Please install package rcom for R-2.8.0 from CRAN and run this command. Then try again. Murray Eisenberg wrote: With R-2.8 installed under Windows XP, I installed (D)COM, specifically using RSrv250.exe. Something's wrong in the configuration. When I try Server 01- Basic Test, I get a pop-up StatConnector Test window. If I click the Start R button, I see: Loading StatConnector Server... Done Initializing R...Function call failed Code: -2147221485 Text: installation problem: unable to load connector and I get a separate Test1 pop-up saying Method '~' of object '~' failed. If instead, I try Excel 01 - R Server Connection demo, immediately I get RExcel.xla opened in the Microsoft Visual Basic debugger with a pop-up window Microsoft Visual Basic saying, Compile error: Can't find project or library. The debugger has stopped at the word Left in the line ExcelVersionMajor = CInt(Left(Application.Version, pos - 1)) of the function ExcelVersionMajor(). I stop the debugger. Excel 2003 is still open. I close it and then reopen it in order to deactivate the RExcel add-in. When I use Tools Add-ins and uncheck RExcel, I get a Microsoft Visual Basic pop-up window saying Can't find project or library. I quit that window and get a VBAProject Password window, which I cancel. Next, I reactivate RExcel add-in and now I get a new pop-up window, References - RExcelVBAlib and I see the item: MISSING RCOM 1.0 Type Library with the message that this is should be in Location: C:\PROGRA~2\R\R-24~1.1\library\rcom\libs\rcom_srv.tlb But I do not have R installed there. Here's my setup: My system PATH includes D:\Stat\R\R2.8\bin (which is correct), and the file rcom_srv.tlb from rcom is in: D:\Stat\R\myRlib\rcom\libs In D:\Stat\R\R-2.8\bin, I have .Renviron, which includes: R_USER=e:/Documents/R R_LIBS=d:/Stat/R/myRlib And that target of R_USER is where my .Rprofile is kept. It includes as last line: library(rcom) and has no trouble, apparently, loading that library when I just start R directly. I also have the Windows system variable R_HOME set to D:\Stat\R\R-2.8. I suspect part of the problem may arise from the file .Renviron that is installed by RSrv250.exe into D:\Stat\R\(D)COM Server\xls. It contains the single line: library(rcom) BUT... where is something picking up the spurious location C:\PROGRA~2\R\R-24~1.1\library\rcom\libs\rcom_srv.tlb for rcom_srv.tlb, and how do I fix this. No virus found in this incoming message. 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-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] MISSING RCOM 1.0 Type Library
RSrv250.exe DOES NOT WORK WITH R-2.8.0 any more. Thomas yesterday sent mail to the list. You need http://rcom.univie.ac.at/download/devel/R_Scilab_DCOM3.0-1B1beta.exe and the package rscproxy from CRAN Murray Eisenberg wrote: Here's an excerpt from the DbgView capture: [3176] looking up 0 registry key at HKCR\Software\R-core\R\InstallPath [3176] looking up 0 registry key at HKLM\Software\R-core\R\InstallPath [3176] loading D:\Stat\R\R-2.8\bin\rproxy.dll [3176] load proxy library from D:\Stat\R\R-2.8\bin\rproxy.dll [3176] Registry information said to load D:\Stat\R\R-2.8\bin\rproxy.dll, failed! [3176] load proxy library from rproxy.dll [3176] Loading rproxy.dll via path failed! I searched for rproxy.dll but do not find it anywhere. What installs that and why might it not get installed? Although I installed (D)COM by using RSrv250.exe, I did look into RSrv250S.zip bu found no rproxy.* there. So I assume that either R itself or else rcom installs rproxy.dll? Thomas Baier wrote: Murray, Murray Eisenberg schrieb: I just did that: 1. Removed existing rcom in library 2. Opened R Console installed rcom from CRAN (via Packages Install package(s). rcom is installed in the library location pointed to by R_LIBS=d:/Stat/R/myRlib which is set in my .Renviron file; I'm no longer using any system environment variable for that. 3. Loaded package rcom from menu Packages Load Package... I note message: Loading required package: rscproxy 4. On R Console command line, execute: comRegisterRegistry() This returns NULL. Is that OK? yes, this is ok. If you're logged in as Administrator or Power User, then everything should work fine now. 5. (Should I have first uninstalled (D)COM and then reinstalled after step #4?) 6. I leave R Console open now. 7. Open Excel 2003 and fro RExcel menu select Start R. Get error message Could not start RServer. Close Excel. Depending on the settings of RExcel, rcom or R/Scilab (D)COM Server will be used. We've just discussed rcom so far. 8. Run the (D)COM Server 01 - Basic Test: click Start R. Get error message Method '~' of object '~' failed and in StatConnector Test window see: Initializing R...Function call failed Code: -2147221485 Text: installation problem: unable to load connector At least now I'm not getting the VBA debugger opening. But something is still very wrong. The Basic Test only applies to R/Scilab (D)COM Server. After installing the correct version for R 2.8.0 (see the list archives for postings from yesterday), this should work fine. If not, I'd recommend to install DbgView and have a look at the output. For me, this output is: [4356] connector: R [4356] DLL:rscproxy.dll [4356] environment:R_HOME [4356] registry key: Software\R-core\R [4356] registry value: InstallPath [4356] version key: [4356] version value: [4356] binary dir: bin [4356] connector: Rold [4356] DLL:rproxy.dll [4356] environment:R_HOME [4356] registry key: Software\R-core\R [4356] registry value: InstallPath [4356] version key: [4356] version value: [4356] binary dir: bin [4356] connector: SciLab [4356] DLL:sciproxy.dll [4356] environment:R_HOME [4356] registry key: Software\Scilab\%s [4356] registry value: SCIPATH [4356] version key:Software\Scilab [4356] version value: LASTINSTALL [4356] binary dir: bin [4356] sc_proxy_find_connector: 008507C8/R (current R) [4356] sc_proxy_find_connector: found R [4356] looking up registry key at HKCU\Software\R-core\R\InstallPath [4356] looking up registry key at HKLM\Software\R-core\R\InstallPath [4356] SetEnvironmentVariable(R_HOME,f:\Programme\R\R-2.8.0) [4356] SetEnvironmentVariable(PATH,C:\APPS\CVS\TCL\bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\Programme\HPQ\IAM\bin;H:\LC32ENV\Tools\Version11\win\bin;H:\LC32ENV\Tools\Version11\win\cmd;C:\Programme\Microsoft SQL Server\90\Tools\binn\;C:\SFU\common\;C:\Programme\TortoiseSVN\bin;c:\Apps\CVS\GNU\WinCVS\CVSNT;c:\h\\LC32ENV\Tools\Version11\lc32dev\Cygnus\1.1.7\bin;c:\Programme\CVSNT\;f:\Programme\R\R-2.8.0\bin) [4356] PATH 8721749s (null) [4356] load proxy library from f:\Programme\R\R-2.8.0\library/rscproxy/libs\rscproxy.dll [4356] No Debugging of rproxy [4356] R_Proxy_parse_parameters() If DbgView does not produce any output, something has gone seriously wrong (on your machine). If DbgView produces a similar output, please study the output if this matches the setup on your machine. Please post the output if you're not sure, but also don't forget to post, where R ist installed and full information about the versions of the various software you have 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
[Rcom-l] ROO (ROOo) Update
The R OpenOffice announced yesterday will be updated a few times (it is still in development) The current version is at http://rcom.univie.ac.at/download/ROOo/ROOo20081014-1.zip The directory name was changed from ROO to ROOo and the third o also was added to the file name. We will stay 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://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] PutDataFrame
uninstall.exe there is OK, that is part of the installation. Fabien Rinaldi wrote: I'm using excel 2000 9.0 and i think it's Rexcel is not installed correctly, in the Rexcel folder i only got the uninstall exe. FR 2008/10/13 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Are you sure Rexcel has been installed correctly? Which version of Excel are you using? Try the following: Navigate to Program FilesRExcel-xls and double click on ActivateRExcel.bat -Original Message- *From:* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]]*On Behalf Of *Fabien Rinaldi *Sent:* 13 October 2008 09:17 *To:* R (D)COM and RExcel server related issues *Subject:* Re: [Rcom-l] PutDataFrame Thanks for the answears, but i 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 menu now has items to activate the addin. This needs to be done for anyother user than the installing user. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: From Excel Go to tools-add-ins and check that RExcel has been selected. There used to be a file called RExcelAddinInstall.xls which would do this for you in previous releases. It seems that this file is not present in the latest releases. Regards Wayne -Original Message- *From:* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]]*On Behalf Of *Fabien Rinaldi *Sent:* 13 October 2008 08:47 *To:* R (D)COM and RExcel server related issues *Subject:* Re: [Rcom-l] PutDataFrame Ok i've check my Rexcel version and it was the 1.75, so i uninstall the Rexcel addin and reinstall the latest Rexcel package but i don't find the way to get access to the Rexcel menu in Excel. FR 2008/10/12 Fabien Rinaldi [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] I'm not at work now, i could only try tomorow to check the version. But i've install the Rsrv250S package and check Rexcel installation Thanks. 2008/10/12, Erich Neuwirth [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: Does this happen with RExcel 3.0-4 (the current version)? Fabien Rinaldi wrote: Thanks for the answer. But i've put a top row with and it doesn't work. When i try with the demo sheet for data transfer, this doesn't work to. But if i put my datas in array this works. Is there a particular format for the datas to complete a dataframe transfert ? Thanks for the answer. Fabien Rinaldi 2008/10/10, Erich Neuwirth [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]: In a dataframe, variables have to have names. You need a top row with the names of the variables. Then the transfer will work. This corresponds to data lists in Excel. They also
Re: [Rcom-l] PutDataFrame
In a dataframe, variables have to have names. You need a top row with the names of the variables. Then the transfer will work. This corresponds to data lists in Excel. They also need a top row with names. BTW RExcel 1.5 is VERY outdated. CRAN has newer versions (packages RExcelInstaller) Fabien Rinaldi wrote: Hi everybody, I've got a newbie pb with Rexcel 1.5. When i'm trying to do a R-- Put-- Dataframe command in excel with a range of numerical values (i'm in foreground server config), when i go to the R console and when i try to check the dataframe, he told me that the dataframe is empty ??? Has someone got an idea. Thanks Fabien Rinaldi ___ 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 No virus found in this incoming message. Checked by AVG - http://www.avg.com Version: 8.0.173 / Virus Database: 270.8.0/1717 - Release 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 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
[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-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] RExcel with ESS
I just spotted this problem also. I am on the road right now (UseR008), and I will do a fixed version next week, BTW: I bever user une letter variable names (outside of dataframes), therefore I neve stumbped on this. On Aug 12, 2008, at 9:07 AM, [EMAIL PROTECTED] wrote: Dear Erich and Scott, Concerning the third point the LegalRandRangeNameFrom function of the RInterfaceSupport module causes the problem. It contains a 'do--loop until' construct which assumes that the name is at least two character long. One possibility is to change it 'while--wend' loop, it does not do anything if length is 1, otherwise the same as it is now. The other possible work around is to define the empty string as non digit in the isdigit function of the same module. -- Vilmos Prokaj Eötvös Loránd University, Department of Probability and Statistics Pázmány Péter sétány 1/C Budapest, 1117 Hungary e-mail:[EMAIL PROTECTED] Thanks for your help everybody... the tips to load the rcom package and hit return a few times to clear up a freeze did the trick. I'm now able to get RExcel in a usable state with ESS. I've noticed a few strange things as I was playing around, I wonder if you might have any thoughts on them: 1) It doesn't seem possible to select Foreground server right away. When I open Excel, then go to RExcel-Set R Server, the Foreground Radio Box is greyed out. The two ways I've been able to get RExcel to work are to (a) choose Background and check the Remote checkbox, then either leave Server address blank, or put in my local machine's name, then click save, then click close and go about using RExcel or (b) Click on the Remote check box, click Save (this activates the Foreground radio box), select Foreground, uncheck Remote, then check RGui visible, then click Save (this greys out Foreground, but it is still selected), then click close and go about using RExcel. 2) The R Server settings don't seem to be persistent from Excel session to Excel session, so every time I open up a new excel, I have to redo the server settings 3) If I try to put a dataframe into the R session and name it with a single-character name, I get an unhandled error in the VBA code; if I try to name it with a number as the last character, and the second to last character is not an underscore, I get a dialog box informing me that the name 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 [EMAIL PROTECTED]wrote: This essentially works, but there is a small bug which still needs to be fixed. Sometimes (especially immediately after Excel tries to connect to such an R process) Excel seems to hang. Typing a few returns in the Emacs window ussualy helps. On Aug 7, 2008, at 7:33 PM, Prokaj Vilmos wrote: Hi Scott, Try to load the rcom package in the ESS terminal before connecting from EXCEL. Scott Stephens írta: Greetings, My preferred way of using R at the command line is through Emacs with the ESS add-on. I would love to be able to use RExcel with ESS in the same way that it's possible to use RExcel with the usual Rgui. I followed the usual installation instructions using ESS as my R terminal, and it seemed to install correctly. However, when within Excel I choose RExcel-R Start, rather than detecting my existing ESS terminal, it instead starts a brand new Rgui terminal to connect to. Has anyone else tried this? Anyone know how to get it working/ if it's possible? Thanks, Scott ___ 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 -- Vilmos Prokaj Eötvös Loránd University, Department of Probability and Statistics Pázmány Péter sétány 1/C Budapest, 1117 Hungary e-mail:[EMAIL PROTECTED] [EMAIL PROTECTED] ___ 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 Didactic Center for Computer Science and Institute for Scientiic Computing University of Vienna ___ 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 ___ 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
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 string functions in VB are not supported, such as Left, Right, Mid, LCase, and UCase. The error messages state that no such functions are supported. I don't know why. They should be standard functions provided in VB. Any ideas on how to solve the problem. Many thanks. Best regards, Eric Fung Hong Kong ___ 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 ___ 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
Re: [Rcom-l] RE: Problem in calling R in Excel
RExcel as a macro RunFromRFile which allows you to give it a filename in Excel-Windows format (single backslashed) and then sources it. Iqbal Hussain wrote: Your problem might be in the string you are passing to RInterface.RRun Try something like this: Sub test() Dim code As String code = source('c://global//source//admin//porto.r' ) Call rinterface.RRun(code) End Sub *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Krishanu Saha *Sent:* 21 July 2008 06:34 *To:* rcom-l@mailman.csd.univie.ac.at *Subject:* [Rcom-l] Problem in calling R in Excel Hi everybody, I am new to R-excel-add in and trying to connect my R code with excel. My R version is 2.5.1 and the R (D)com is V 2.01. The code I am using to call R is Call RInterface.RRun(source( Replace(ThisWorkbook.Path, \, /) /PORTO)) , where PORTO is the R source file containing my code. Please help me sort the problem. Thank you all. Regards, Krishanu Saha * * This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Any views or opinions presented are solely those of the author and do not necessarily represent those of Amba Holdings Inc., and/or its affiliates. Important additional terms relating to this email can be obtained at http://www.ambaresearch.com/disclaimer ** The information provided in this e-mail is confidential and is for the sole use of the recipient. It may not be disclosed, copied or distributed in any form without the express permission of Henderson Global Investors and to the extent that it is passed on, care must be taken to ensure that this is in a form which accurately reflects the information presented here. Whilst Henderson Global Investors believe that the information is correct at the date of this e-mail, no warranty or representation is given to this effect and no responsibility can be accepted by Henderson Global Investors to any end users for any action taken on the basis of this information. Henderson Global Investors is the name under which Henderson Global Investors Limited (registered no. 906355), Henderson Fund Management plc (registered no. 2607112), Henderson Investment Funds Limited (registered no. 2678531), Henderson Investment Management Limited (registered no. 1795354) Henderson Alternative Investment Advisor Limited (registered no. 962757) and Henderson Equity Partners Limited (registered no.2606646) (each incorporated and registered in England and Wales with registered office at 4 Broadgate, London EC2M 2DA and authorised and regulated by the Financial Services Authority) provide investment products and services. Henderson Secretarial Services Limited (incorporated and registered in England and Wales, registered no. 1471624, registered office 4 Broadgate, London EC2M 2DA) is the name under which company secretarial services are provided. All these companies are wholly owned subsidiaries of Henderson Group plc (incorporated and registered in England and Wales, registered no. 2072534, registered office 4 Broadgate, London EC2M 2DA). We may record telephone calls or email for our mutual protection and to improve customer service. ** ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] Detecting if RExcel is installed
On Jul 17, 2008, at 11:58 PM, Andrew McLachlan wrote: Thank you Erich I have just been reading about the AddIns collection and was wondering whether to use that approach or not. Your reply has stopped me wondering :-) and I will be adding your code to my project. During my testing of the functions below, I found that they worked as expected. That is, when RExcel2007 in the Add-ins list was checked, the result was True, and when RExcel2007 in the Add-ins list was unchecked, the result was False. However, I did a further test and got an unexpected result. I unchecked RExcel2007 to uninstall it and then installed and ran my own add-in that uses RExcel. I found that my own add-in worked and used R correctly. This was unexpected. I had a assumed that if the RExcel add-in was unchecked, then the RExcel functions would be unavailable. Is this because I have added a reference to RExcelVBALib in the Tools Reference list? That is probably the reason, but I have never tested this, therefore I do not know in detail. My guess it the followning. The checkmark does not tell yo if the addin is installed, but if it is active. The fact that the addin is on the list means that it is installed. My guess is that the installed property better should be called activated. I am wondering about my user installing my add-in without RExcel being present and, thereby, generating uncontrolled errors. I am wanting to detect when the RExcel macros are available and when they are not so that I can give a warning to the user when they try to do things that require RExcel. Should I be doing this, do you think? Or, should I just be making sure that I have RExcel properly installed before installing my add-in (my defensive programming nerves start to twitch 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] Function AddinInstalledAndEnabled(aiName As String) As Boolean Dim result As Boolean Dim ai As AddIn result = False For Each ai In Application.AddIns If ai.Name = aiName Then result = result Or ai.Installed End If If result Then Exit For Next ai AddinInstalledAndEnabled = result End Function 'Function code by Erich Neuwirth [EMAIL PROTECTED] Function RExcelAvailable() As Boolean RExcelAvailable = AddinInstalledAndEnabled(RExcel.xla) or _ AddinInstalledAndEnabled(RExcel2007.xlam) End Function Cheers, Andrew Mc -- Andrew McLachlan, Biometrician Crop Food Research, Palmerston North, New Zealand. Tel +64-6-356-8300, +64-6-355-6110 (DDI) On 17/07/2008 at 8:06 p.m., Erich Neuwirth [EMAIL PROTECTED] wrote: Function AddinInstalledAndEnabled(aiName As String) As Boolean Dim result As Boolean result = False For Each ai In Application.AddIns If ai.Name = aiName Then result = result Or ai.Installed End If If result Then Exit For Next ai AddinInstalledAndEnabled = result End Function Function RExcelAvailable() As Boolean RExcelAvailable = AddinInstalledAndEnabled(RExcel.xla) or _ AddinInstalledAndEnabled(RExcel2007.xlam) End Function Andrew McLachlan wrote: Hi All Can anyone suggest to me ways of using VBA from within Excel to detect whether the RExcel add-in is installed or not? My first thought is perhaps to check for the presence of some RExcel constants, for example, RExcelVersion. Cheers, Andrew Mc Visit our website at http://www.crop.cri.nz __ CAUTION: The information contained in this email is privileged and confidential. If you read this message and you are not the intended recipient, you are hereby notified that any use, dissemination, distribution or reproduction of all or part of the contents is prohibited. If you receive this message in error, please notify the sender immediately. Any opinions or views expressed in this message are those of the individual sender and may not represent those of their employer. ___ 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 Visit our website at http://www.crop.cri.nz __ CAUTION: The information contained in this email is privileged and confidential. If you read this message and you are not the intended recipient, you are hereby notified that any use, dissemination, distribution or reproduction of all or part of the contents is prohibited. If you receive this message in error, please notify the sender immediately. Any opinions or views expressed
Re: [Rcom-l] Detecting if RExcel is installed
Function AddinInstalledAndEnabled(aiName As String) As Boolean Dim result As Boolean result = False For Each ai In Application.AddIns If ai.Name = aiName Then result = result Or ai.Installed End If If result Then Exit For Next ai AddinInstalledAndEnabled = result End Function Function RExcelAvailable() As Boolean RExcelAvailable = AddinInstalledAndEnabled(RExcel.xla) or _ AddinInstalledAndEnabled(RExcel2007.xlam) End Function Andrew McLachlan wrote: Hi All Can anyone suggest to me ways of using VBA from within Excel to detect whether the RExcel add-in is installed or not? My first thought is perhaps to check for the presence of some RExcel constants, for example, RExcelVersion. Cheers, Andrew Mc Visit our website at http://www.crop.cri.nz __ CAUTION: The information contained in this email is privileged and confidential. If you read this message and you are not the intended recipient, you are hereby notified that any use, dissemination, distribution or reproduction of all or part of the contents is prohibited. If you receive this message in error, please notify the sender immediately. Any opinions or views expressed in this message are those of the individual sender and may not represent those of their employer. ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] Background RExcel
Simply put: NO. If you want to see the GUI, use the foregound server. You can develop a program with the foreground server and later use the beckgroud server when you deply it to users. [EMAIL PROTECTED] wrote: When using RExcel, there is an option to set the instance of R used as Background. When in this mode, is there any way to cause a GUI to appear for that instance of R. I would like to do this so I can view the variables and do other error checking while developing my spreadsheet. Thanks. ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] help
x.EvaluateNoReturn(source('myfile.R')) Abderrazzak MANY wrote: Hello, I'm using R from VB for Microsoft Access and I want to know if there is a command for running R files direclty ? (something like source(MyFile.R)) Thanks. 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 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@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
[Rcom-l] RExcelInstaller_2.0-35
There is a new version of the RExcelInstaller on CRAN. Some minor bugfixing and one nice thing. When you have created an R graph in an R window, right clicking on an Excel cell will allow you to paste a copy of the graph directly on the Excel worksheet. The cell right click menu also has an item 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 ___ 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
Re: [Rcom-l] help
The wiki at http://rcom.univie.ac.at also has information about using rcom and (D)COM server from different applications. Thomas Baier wrote: Abderrazzak MANY schrieb: Hello, I would like to use R invisibly from Microsoft Access. I want to know if it is possible and how. it is possible using VBA and R (D)COM Server. Have a look at the examples for VB6 Thomas ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] RAndFriendsSetup2070V20-5 issues
Dear friends, and especially Wayne I just put up http://rcom.univie.ac.at/download/devel/RExcelInstaller_2.0-33.zip It should solve the problem Wayne descriped. Please download and install from local zip file. Then start R and do library(RExcelInstaller) RExcelInstall() This will install 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 Sent: 29 May 2008 14:53 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] RAndFriendsSetup2070V20-5 issues This was due to a recent change caused by another error. I will put up a new version later tonight. [EMAIL PROTECTED] wrote: Hi there, I have just downloaded and installed the latest version of RandFriends ( RAndFriendsSetup2070V20-5). It installed with no problems or error messages using Excel 2007 on both Vista and XP machines. However, the RExcel examples are not working correctly on both XP and Vista. FOr the RDemoRecalc I get the following pop-up error message: Error -2147220502 in Module RExcel.RServer Error running expression eval(parse(text=z-(cor.test(xvar,yvar I get a similar error message with the Interactive Graphics demo. Regards, Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Gary Prothero Sent: 28 May 2008 16:07 To: 'R (D)COM and RExcel server related issues' Subject: RE: [Rcom-l] Evaluating NA value crashes R Julien, I handle the NA's on the R side by resetting the NA's to my own missing value (in my case -) before importing to C#. Gary Prothero ProWorks Corporation [EMAIL PROTECTED] www.proworks.com (541) 752-9885 ext. 1001 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Julien Vanwinsberghe Sent: Wednesday, May 28, 2008 12:53 AM To: 'R (D)COM and RExcel server related issues' Subject: [Rcom-l] Evaluating NA value crashes R Dear all, Evaluating NA value with a StatConnectorClass object ('Robj.Evaluate(NA);' in C#) causes this error: unexpected fatal error in back-end implementation. release the object!. So my program crashes when some results that I bring back from R contain NA values. Is it normal? And would you have some ideas to avoid this type of error? Thanks, Julien ___ 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 ___ 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 ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] RAndFriendsSetup2070V20-5 issues
Corrected version is up. Hopefully this is the version which remains stable for a few months now. [EMAIL PROTECTED] wrote: Hi Erich, Just tested the latest version of Rexcel (2.0-33) but unfortunately I am getting the same errors as before. Regards Wayne -Original Message- 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/RExcelInstaller_2.0-33.zip It should solve the problem Wayne descriped. Please download and install from local zip file. Then start R and do library(RExcelInstaller) RExcelInstall() This will install 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 Sent: 29 May 2008 14:53 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] RAndFriendsSetup2070V20-5 issues This was due to a recent change caused by another error. I will put up a new version later tonight. [EMAIL PROTECTED] wrote: Hi there, I have just downloaded and installed the latest version of RandFriends ( RAndFriendsSetup2070V20-5). It installed with no problems or error messages using Excel 2007 on both Vista and XP machines. However, the RExcel examples are not working correctly on both XP and Vista. FOr the RDemoRecalc I get the following pop-up error message: Error -2147220502 in Module RExcel.RServer Error running expression eval(parse(text=z-(cor.test(xvar,yvar I get a similar error message with the Interactive Graphics demo. Regards, Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Gary Prothero Sent: 28 May 2008 16:07 To: 'R (D)COM and RExcel server related issues' Subject: RE: [Rcom-l] Evaluating NA value crashes R Julien, I handle the NA's on the R side by resetting the NA's to my own missing value (in my case -) before importing to C#. Gary Prothero ProWorks Corporation [EMAIL PROTECTED] www.proworks.com (541) 752-9885 ext. 1001 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Julien Vanwinsberghe Sent: Wednesday, May 28, 2008 12:53 AM To: 'R (D)COM and RExcel server related issues' Subject: [Rcom-l] Evaluating NA value crashes R Dear all, Evaluating NA value with a StatConnectorClass object ('Robj.Evaluate(NA);' in C#) causes this error: unexpected fatal error in back-end implementation. release the object!. So my program crashes when some results that I bring back from R contain NA values. Is it normal? And would you have some ideas to avoid this type of error? Thanks, Julien ___ 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 ___ 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 ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] RAndFriendsSetup2070V20-5 issues
Do you have another demo file open at the same time? [EMAIL PROTECTED] wrote: Hi there, I have just downloaded and installed the latest version of RandFriends ( RAndFriendsSetup2070V20-5). It installed with no problems or error messages using Excel 2007 on both Vista and XP machines. However, the RExcel examples are not working correctly on both XP and Vista. FOr the RDemoRecalc I get the following pop-up error message: Error -2147220502 in Module RExcel.RServer Error running expression eval(parse(text=z-(cor.test(xvar,yvar I get a similar error message with the Interactive Graphics demo. Regards, Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Gary Prothero Sent: 28 May 2008 16:07 To: 'R (D)COM and RExcel server related issues' Subject: RE: [Rcom-l] Evaluating NA value crashes R Julien, I handle the NA's on the R side by resetting the NA's to my own missing value (in my case -) before importing to C#. Gary Prothero ProWorks Corporation [EMAIL PROTECTED] www.proworks.com (541) 752-9885 ext. 1001 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Julien Vanwinsberghe Sent: Wednesday, May 28, 2008 12:53 AM To: 'R (D)COM and RExcel server related issues' Subject: [Rcom-l] Evaluating NA value crashes R Dear all, Evaluating NA value with a StatConnectorClass object ('Robj.Evaluate(NA);' in C#) causes this error: unexpected fatal error in back-end implementation. release the object!. So my program crashes when some results that I bring back from R contain NA values. Is it normal? And would you have some ideas to avoid this type of error? Thanks, Julien ___ 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 ___ 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 ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] RAndFriendsSetup2070V20-5 issues
This was due to a recent change caused by another error. I will put up a new version later tonight. [EMAIL PROTECTED] wrote: Hi there, I have just downloaded and installed the latest version of RandFriends ( RAndFriendsSetup2070V20-5). It installed with no problems or error messages using Excel 2007 on both Vista and XP machines. However, the RExcel examples are not working correctly on both XP and Vista. FOr the RDemoRecalc I get the following pop-up error message: Error -2147220502 in Module RExcel.RServer Error running expression eval(parse(text=z-(cor.test(xvar,yvar I get a similar error message with the Interactive Graphics demo. Regards, Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Gary Prothero Sent: 28 May 2008 16:07 To: 'R (D)COM and RExcel server related issues' Subject: RE: [Rcom-l] Evaluating NA value crashes R Julien, I handle the NA's on the R side by resetting the NA's to my own missing value (in my case -) before importing to C#. Gary Prothero ProWorks Corporation [EMAIL PROTECTED] www.proworks.com (541) 752-9885 ext. 1001 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Julien Vanwinsberghe Sent: Wednesday, May 28, 2008 12:53 AM To: 'R (D)COM and RExcel server related issues' Subject: [Rcom-l] Evaluating NA value crashes R Dear all, Evaluating NA value with a StatConnectorClass object ('Robj.Evaluate(NA);' in C#) causes this error: unexpected fatal error in back-end implementation. release the object!. So my program crashes when some results that I bring back from R contain NA values. Is it normal? And would you have some ideas to avoid this type of error? Thanks, Julien ___ 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 ___ 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 ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] RExcel - foreground server
Please install the latest version of the RExcelInstaller package, available in http://rcom.univie.ac.at/download/devel and tell us if the problem persists. Werner Wernersen wrote: Hi, I have a problem using RExcel with a foreground server: in RExcel menu as well as in the window called by set server the foreground server option is grayed out. I have installed the rcom package and also tried to open R and type require(rcom), as explained on http://sunsite.univie.ac.at/rcom/excel/index.html, but it does not help. What am I missing? Many thanks, Werner P.S.: Sorry for having posted this on r-help first. I had overlooked this dedicated list. __ Gesendet von Yahoo! Mail. Dem pfiffigeren Posteingang. http://de.overview.mail.yahoo.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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] Regarding ANOVA
This is not a rcom-l question. Please post this kind of question to the r-help mailing list. Guru S wrote: Hi, According to Bates' comments , I executed nonlinear fit model using anova.nls() this command is not executing in R. if i execute methods(anova) then anova.nls is coming as non visible functions as shown below. How to i execute it. Pl help me any one methods(anova) [1] anova.glmanova.glmlist anova.lm anova.loess anova.mlm anova.nls Non-visible functions are asterisked Thanks Regards, Guru S JS RED ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] R(D)COM
We are currently changing the architecture. RExcel became a full CRAN package only recently. Currently, installing RSrv250_pl1.exe installs an outdated version of RExcel, and it even installs in in a now inconvenient place. If you wait for about 2 weeks, we will have new packages and installers for all our stuff. In the meantime you can safely use the foreground server. Felipe Carrillo wrote: Hi all: Is R(D)COM a regular package that can be updated from CRAN or it just gets installed with RExcel? I am asking this because I have deleted my Older RExcel version and R(D)COM was deleted with it and now I don't have a background server again. I took care of this by installing the old RExcel back but I was just wondering and thought that the new version would install R(D)COM with it. Thanks Felipe D. Carrillo Fishery Biologist Department of the Interior US Fish Wildlife Service California, USA Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] New RAndFriends
Wayne, I uploaded http://rcom.univie.ac.at/download/devel/DCOMNoExcel-1.exe Please try if this installs without the error on Vista. [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: RegisterTypeLib failed; code 0x8002801C. Error accessing the OLE registry. It also complained that it could not find an Excel version compatible with RExcel despite the fact that I was using Excel 2007. I manually installed RExcel and also installed rcom. Most of the examples worked but I had no luck getting the Graphics with Sliders example to work. BTW, the error message from uninstaling 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: 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/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 testing of the new RAndFriends including the new R 2.7.0 (RAndFriendsSetup2070V20.exe). I get the folowing error message when trying to install using Vista Ultimate edition: C\Windows\System32\stdole2.tlb Unable to register the type library: RegisterTypeLib failed; code 0x8002801C. Error accessing the OLE registry. I'm fairly sure the error message relates to the R(D)Com part of the installation. However, if I continue installation by choosing to ignore this message then the installation seems to work fine! Following a brief websearch I have found a couple of other cases reported where the same error occurs. The file stdole2.tlb relates to visual basic. I think the problem relates to the Inno setup installation trying to overwrite the C\Windows\System32\stdole2.tlb where the file already exists, see http://www.smurphy.co.uk/board/viewtopic.php?t=1465 and hence why choosing ignore works fine. I did indeed find that C\Windows\System32\stdole2.tlb was already present on my machine. The following article discusses the same error message when using Inno Setup: http://www.vbforums.com/archive/index.php/t-468770.html and points to a solution. I did get another error message when uninstalling R(D)Com server,namely: Runtime Error (at 11:90) Internal Error. Cannot call ISCOMPENENTSELECTED function during uninstall. but installation seemed to work fine despite this message. Regards, Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[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 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@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
[Rcom-l] Re: Error
Problem solved. The mechanism for running R files has changed. I am using a textConncetion now. Your R code has calls closeAllConnections and so closes also the connection RExcel is using. As far as I see your code is not opening connections, so you don't have to close either. This is probably a remainder from the original tests when you used the read.table statements which are now commented out. Using a command with global side effects like closeAllConnections is not a good idea in a complex system like RExcel. Doing global stuff in as subroutine called by somebody else (RExcel in out case) is something one should definitely avoid. An additional remark. You also have a lot of implicit print statements when you just use variable names as commands. This commands do not produce output in the RGui window, and they also do not transmit information to Excel. So it would be better to remove these commands also. Your macros also use a lot of Select statements, probably because you used the macro recorder. Instead of Range(J2).Select Range(Selection, Selection.End(xlToRight)).Select Range(Selection, Selection.End(xlDown)).Select Selection.ClearContents you could also do Dim StartCell As Range Set StartCell = Range(J2) Range(StartCell, StartCell.End(xlDown).End(xlToRight)).ClearContents When working with ranges in macros it is not necessary to select them. To work with ranges interactively you have to select them. Therefore, the macro recorder will always use Select, but in your VBA code they are unnecessary. Felipe Carrillo wrote: Erich: I have attached the workbook and the R script. When the workbook is opened it creates a new menu called MST Model with a submenu Get MST CI's. Click on the submenu to run the Run_RStatistics macro. 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 and then the message saying that the errors were too many to count and continued executing correctly. I still get the values that I want but with the error messages. I traced the errors to the RServer.Module and couldn't figure out where they are occurring. I wonder if there's a way to put a On error resume next statement because in reality there's not errors as I still getting the desired results that I was getting with the older version. I uninstalled RExcelInstaller and ran my code with the older version and its working nicely again. Thanks Erich for the great job. --- Erich Neuwirth [EMAIL PROTECTED] wrote: Please try the following addin file Put it in C:\Program Files\RExcel\xls but save the original version first in a safe place and check what happens. -- 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 Felipe D. Carrillo Fishery Biologist Department of the Interior US Fish Wildlife Service California, USA Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- 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 Felipe D. Carrillo Fishery Biologist Department of the Interior US Fish Wildlife Service California, USA Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ -- 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@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
Re: [Rcom-l] New RAndFriends
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 testing of the new RAndFriends including the new R 2.7.0 (RAndFriendsSetup2070V20.exe). I get the folowing error message when trying to install using Vista Ultimate edition: C\Windows\System32\stdole2.tlb Unable to register the type library: RegisterTypeLib failed; code 0x8002801C. Error accessing the OLE registry. I'm fairly sure the error message relates to the R(D)Com part of the installation. However, if I continue installation by choosing to ignore this message then the installation seems to work fine! Following a brief websearch I have found a couple of other cases reported where the same error occurs. The file stdole2.tlb relates to visual basic. I think the problem relates to the Inno setup installation trying to overwrite the C\Windows\System32\stdole2.tlb where the file already exists, see http://www.smurphy.co.uk/board/viewtopic.php?t=1465 and hence why choosing ignore works fine. I did indeed find that C\Windows\System32\stdole2.tlb was already present on my machine. The following article discusses the same error message when using Inno Setup: http://www.vbforums.com/archive/index.php/t-468770.html and points to a solution. I did get another error message when uninstalling R(D)Com server,namely: Runtime Error (at 11:90) Internal Error. Cannot call ISCOMPENENTSELECTED function during uninstall. but installation seemed to work fine despite this message. Regards, Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[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 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@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
Re: [Rcom-l] New RAndFriends
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 (D)COM Server. [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: RegisterTypeLib failed; code 0x8002801C. Error accessing the OLE registry. It also complained that it could not find an Excel version compatible with RExcel despite the fact that I was using Excel 2007. I manually installed RExcel and also installed rcom. Most of the examples worked but I had no luck getting the Graphics with Sliders example to work. BTW, the error message from uninstaling 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: 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/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 testing of the new RAndFriends including the new R 2.7.0 (RAndFriendsSetup2070V20.exe). I get the folowing error message when trying to install using Vista Ultimate edition: C\Windows\System32\stdole2.tlb Unable to register the type library: RegisterTypeLib failed; code 0x8002801C. Error accessing the OLE registry. I'm fairly sure the error message relates to the R(D)Com part of the installation. However, if I continue installation by choosing to ignore this message then the installation seems to work fine! Following a brief websearch I have found a couple of other cases reported where the same error occurs. The file stdole2.tlb relates to visual basic. I think the problem relates to the Inno setup installation trying to overwrite the C\Windows\System32\stdole2.tlb where the file already exists, see http://www.smurphy.co.uk/board/viewtopic.php?t=1465 and hence why choosing ignore works fine. I did indeed find that C\Windows\System32\stdole2.tlb was already present on my machine. The following article discusses the same error message when using Inno Setup: http://www.vbforums.com/archive/index.php/t-468770.html and points to a solution. I did get another error message when uninstalling R(D)Com server,namely: Runtime Error (at 11:90) Internal Error. Cannot call ISCOMPENENTSELECTED function during uninstall. but installation seemed to work fine despite this message. Regards, Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[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 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@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
Re: [Rcom-l] New RAndFriends
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: RegisterTypeLib failed; code 0x8002801C. Error accessing the OLE registry. It also complained that it could not find an Excel version compatible with RExcel despite the fact that I was using Excel 2007. I manually installed RExcel and also installed rcom. Most of the examples worked but I had no luck getting the Graphics with Sliders example to work. BTW, the error message from uninstaling 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: 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/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 testing of the new RAndFriends including the new R 2.7.0 (RAndFriendsSetup2070V20.exe). I get the folowing error message when trying to install using Vista Ultimate edition: C\Windows\System32\stdole2.tlb Unable to register the type library: RegisterTypeLib failed; code 0x8002801C. Error accessing the OLE registry. I'm fairly sure the error message relates to the R(D)Com part of the installation. However, if I continue installation by choosing to ignore this message then the installation seems to work fine! Following a brief websearch I have found a couple of other cases reported where the same error occurs. The file stdole2.tlb relates to visual basic. I think the problem relates to the Inno setup installation trying to overwrite the C\Windows\System32\stdole2.tlb where the file already exists, see http://www.smurphy.co.uk/board/viewtopic.php?t=1465 and hence why choosing ignore works fine. I did indeed find that C\Windows\System32\stdole2.tlb was already present on my machine. The following article discusses the same error message when using Inno Setup: http://www.vbforums.com/archive/index.php/t-468770.html and points to a solution. I did get another error message when uninstalling R(D)Com server,namely: Runtime Error (at 11:90) Internal Error. Cannot call ISCOMPENENTSELECTED function during uninstall. but installation seemed to work fine despite this message. Regards, Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[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 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@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
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 function vor a function from RExcel. Christian Prinoth wrote: 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 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 in questo messaggio sono inviate dal mittente a proprio nome e non costituiscono una posizione ufficiale di Epsilon SGR. Questo messaggio e' confidenziale e se non e' a Lei indirizzato Le saremmo grati se, via e-mail, ne comunicasse l'errata ricezione al mittente. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in is own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in his own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] PutArrayFromVBA: numeric vs string
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 probably at least half a year away) will take care of this more carefully. But you really need to create an Error value in VBA to transfer something as missing. Currently, PutArrayFromVBA assume that all the array elements have the same data type. So you should do some R programming after transfer to clean up missing data. When you read a cell with an NA value 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) 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 arr(LBound(arr)) = CStr(arr(LBound(arr))) ElseIf n = 2 Then arr(LBound(arr), LBound(arr, 2)) = CStr(arr(LBound(arr), LBound(arr, 2))) Else Stop End If putarrayfromvba VarName, arr If n = 0 Or n = 1 Then rrun VarName -as.numeric( VarName ) ElseIf n = 2 Then rrun VarName -matrix(as.numeric( VarName ), UBound(arr) - LBound(arr) + 1 , UBound(arr, 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 (D)COM and RExcel 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 function vor a function from RExcel. Christian Prinoth wrote: 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 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 in questo messaggio sono inviate dal mittente a proprio nome e non costituiscono una posizione ufficiale di Epsilon SGR. Questo messaggio e' confidenziale e se non e' a Lei indirizzato Le saremmo grati se, via e-mail, ne comunicasse l'errata ricezione al mittente. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in is own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in his own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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 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 posizione ufficiale di Epsilon SGR. Questo messaggio e' confidenziale e se non e' a Lei indirizzato Le saremmo grati se, via e-mail, ne comunicasse l'errata ricezione al mittente. The information and opinions contained in this message do not constitute an official position of Epsilon SGR and are communicated by the sender in is own name. This message is confidential, if you are not the intended recipient, please notify the sender immediately. The information and opinions contained in this message do not constitute an official position of Epsilon SGR
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))) Everything was working fine with the older version Rsrv250_p|1.exe. I am transferring 52 weeks of data (one week at the time) to R and then importing back to excel only one row of data. After the error message it still executes and after the third error message it dissapears and executes the rest of the weeks just fine. Does anyone one know what has changed with the new version? Thanks Felipe D. Carrillo Fishery Biologist Department of the Interior US Fish Wildlife Service California, USA Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ 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 ___ 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
Re: [Rcom-l] Unable to change R Server Config
It is probably best to uninstall everything. The Control Panel item Add or Remove Programs should have an item R/Scilab (D)COM server and RExcel1.75 (or similar) This should allow you to uninstall. otherwise, you should do it manually with the following command line C:\Program Files\R\(D)COM Server\bin\StatConnectorSrv.exe /UnRegServer (possibly you have to use a different path) I will roll a new package RAndFriends later today which then will take care of installing a complete working system. Today R 2.7.0 will be released, and once that is out I will create a new RAndFriends. [EMAIL PROTECTED] wrote: Hi Erich, Thanks for your help. I have a couple of questions though. Apologies if they seem stupid. 1) Do you mean install RSrv250_pl2.exe on top of the Rpackage version of RExcel or RSrv250_pl1.exe or uninstall all components and install RSrv250_pl2.exe stand alone? 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 Subject: Re: [Rcom-l] Unable to change R Server Config pl_1 installs an outdated version of the xls sheets. Please unregister the (D)COM server and install http://rcom.univie.ac.at/download/devel/RSrv250_pl2.exe Use the following commandline: RSrv250_pl2.exe /components=localserver,simpletest,remoteserver,development,samples Check if this solves your problem. [EMAIL PROTECTED] wrote: Hi there, I have just installed the latest version of RExcel as a package from CRAN using windows XP with Excel 2007 and R2.6.1. Installation seemed to work fine and all the demos included in the package worked correctly. However, I am having trouble changing the server configuration from foreground to background using the options: RExcel-Set R Server- Configure R Server(s) from the RExcel menu. I followed the instructions to allow access to the visual basic project. Namely-Macro Security and then check the box trust access to the VBA project object model close Excel down and reopen. However, I stilll dont get the option to choose a background server, the checkbox for background server is not enabled and still dulled out. I tried installing R(D)Com version Rsrv250_pl1.exe to see if it was a problem with my pc settings. This version allowed me to select a background server (but not all the examples worked!). Has anyone else come accross this problem? Regards Wayne Wayne Jones Statistical Consultant Shell Global Solutions (UK) Shell Technology Centre Thornton, P.O. Box 1, Chester CH1 3SH, United Kingdom *Tel:* +44 (0) 151 373 5977* * *Fax:* +44 (0) 151 373 5384* * *Mobile:* +44 (0) 7896 536026 *Email:* [EMAIL PROTECTED] *Internet:*** www.shell.com/globalsolutions/statisticsandchemometrics /Shell Global Solutions (UK) is a division of Shell Research Limited which has its Registered Office at Shell Centre, London SE1 7NA and is registered in England Wales with No.539964./ ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] Unable to change R Server Config
The Control panel uninstall essentially just call the uninstall program you mention. But please do an uninstall before you install the next RAndFriends. [EMAIL PROTECTED] wrote: Thanks Erich, Apologies for the confusion. I was unaware that unregistering the server was the same process as uninstalling the (D)Com server. I generally uninstall R(D)COM server by using the uninstall application in C:\Program Files\R\(D)COM Server\uninsl000. I take it this this not the recommended way to uninstall? I will wait for the new R and Friends to test further. THanks for your helkp it is much 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 everything. The Control Panel item Add or Remove Programs should have an item R/Scilab (D)COM server and RExcel1.75 (or similar) This should allow you to uninstall. otherwise, you should do it manually with the following command line C:\Program Files\R\(D)COM Server\bin\StatConnectorSrv.exe /UnRegServer (possibly you have to use a different path) I will roll a new package RAndFriends later today which then will take care of installing a complete working system. Today R 2.7.0 will be released, and once that is out I will create a new RAndFriends. [EMAIL PROTECTED] wrote: Hi Erich, Thanks for your help. I have a couple of questions though. Apologies if they seem stupid. 1) Do you mean install RSrv250_pl2.exe on top of the Rpackage version of RExcel or RSrv250_pl1.exe or uninstall all components and install RSrv250_pl2.exe stand alone? 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 Subject: Re: [Rcom-l] Unable to change R Server Config pl_1 installs an outdated version of the xls sheets. Please unregister the (D)COM server and install http://rcom.univie.ac.at/download/devel/RSrv250_pl2.exe Use the following commandline: RSrv250_pl2.exe /components=localserver,simpletest,remoteserver,development,samples Check if this solves your problem. [EMAIL PROTECTED] wrote: Hi there, I have just installed the latest version of RExcel as a package from CRAN using windows XP with Excel 2007 and R2.6.1. Installation seemed to work fine and all the demos included in the package worked correctly. However, I am having trouble changing the server configuration from foreground to background using the options: RExcel-Set R Server- Configure R Server(s) from the RExcel menu. I followed the instructions to allow access to the visual basic project. Namely-Macro Security and then check the box trust access to the VBA project object model close Excel down and reopen. However, I stilll dont get the option to choose a background server, the checkbox for background server is not enabled and still dulled out. I tried installing R(D)Com version Rsrv250_pl1.exe to see if it was a problem with my pc settings. This version allowed me to select a background server (but not all the examples worked!). Has anyone else come accross this problem? Regards Wayne Wayne Jones Statistical Consultant Shell Global Solutions (UK) Shell Technology Centre Thornton, P.O. Box 1, Chester CH1 3SH, United Kingdom *Tel:* +44 (0) 151 373 5977* * *Fax:* +44 (0) 151 373 5384* * *Mobile:* +44 (0) 7896 536026 *Email:* [EMAIL PROTECTED] *Internet:*** www.shell.com/globalsolutions/statisticsandchemometrics /Shell Global Solutions (UK) is a division of Shell Research Limited which has its Registered Office at Shell Centre, London SE1 7NA and is registered in England Wales with No.539964./ ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
[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-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] Unable to change R Server Config
pl_1 installs an outdated version of the xls sheets. Please unregister the (D)COM server and install http://rcom.univie.ac.at/download/devel/RSrv250_pl2.exe Use the following commandline: RSrv250_pl2.exe /components=localserver,simpletest,remoteserver,development,samples Check if this solves your problem. [EMAIL PROTECTED] wrote: Hi there, I have just installed the latest version of RExcel as a package from CRAN using windows XP with Excel 2007 and R2.6.1. Installation seemed to work fine and all the demos included in the package worked correctly. However, I am having trouble changing the server configuration from foreground to background using the options: RExcel-Set R Server- Configure R Server(s) from the RExcel menu. I followed the instructions to allow access to the visual basic project. Namely-Macro Security and then check the box trust access to the VBA project object model close Excel down and reopen. However, I stilll dont get the option to choose a background server, the checkbox for background server is not enabled and still dulled out. I tried installing R(D)Com version Rsrv250_pl1.exe to see if it was a problem with my pc settings. This version allowed me to select a background server (but not all the examples worked!). Has anyone else come accross this problem? Regards Wayne Wayne Jones Statistical Consultant Shell Global Solutions (UK) Shell Technology Centre Thornton, P.O. Box 1, Chester CH1 3SH, United Kingdom *Tel:* +44 (0) 151 373 5977* * *Fax:* +44 (0) 151 373 5384* * *Mobile:* +44 (0) 7896 536026 *Email:* [EMAIL PROTECTED] *Internet:*** www.shell.com/globalsolutions/statisticsandchemometrics /Shell Global Solutions (UK) is a division of Shell Research Limited which has its Registered Office at Shell Centre, London SE1 7NA and is registered in England Wales with No.539964./ ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] RV: Description of Function
, _ Category:=RExcel Application.MacroOptions Macro:=RSetApplyA, _ Description:=Applies function to arguments argstring (R values, arguments given as string), assigns result to R variable. Return value of RSetApplyA is the name of the assigned variable, _ Category:=RExcel Application.MacroOptions Macro:=MakeArgs, _ Description:=Creates a string with unnamed and named R arguments from an Excel range. If transpose=FALSE argument range is oriented columnwise, otherwise rowwise. Used to build argument strings for RApplyA, RApplyAC, RCallA, and RSetApplyA, _ Category:=RExcel Application.MacroOptions Macro:=RNumber, _ Description:=Converts a number to a string with the decimal separators needed by R, _ Category:=RExcel END OF CODE Kind Regards *ADVERTENCIA:** * Este mensaje, su contenido y sus archivos adjuntos son confidenciales. Está exclusivamente dirigido al usuario o usuarios de destino. Si, por un error de envío o transmisión, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique este hecho al remitente. Si usted no es el destinatario final de este mensaje no está autorizado a usar, imprimir, copiar o difundir este mensaje bajo ningún concepto, agradeciéndole que proceda de inmediato a la destrucción del mismo. *DISCLAIMER:** * The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in relation to the contents of this information is strictly prohibited and may be unlawful. Neither the sender nor the represented institution are liable for the correct and complete transmission of the contents of an e-mail, or for its timely receipt. *Jose Luis Gilsanz Gomez* *Tasaciones Hipotecarias - Estadistica* ** *Atisreal España* Maria de Molina,54 28006 Madrid Tel. +34 91 454 96 94 Fax +34 91 782 21 64 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.atisreal.es http://www.atisreal.es/ - www.tasacionesh.es http://www.tasacionesh.es/ Tildes ortograficas omitidas intencionadamente por motivos de compatibilidad ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] RV: Description of Function
variable, _ Category:=RExcel Application.MacroOptions Macro:=RSetApplyA, _ Description:=Applies function to arguments argstring (R values, arguments given as string), assigns result to R variable. Return value of RSetApplyA is the name of the assigned variable, _ Category:=RExcel Application.MacroOptions Macro:=MakeArgs, _ Description:=Creates a string with unnamed and named R arguments from an Excel range. If transpose=FALSE argument range is oriented columnwise, otherwise rowwise. Used to build argument strings for RApplyA, RApplyAC, RCallA, and RSetApplyA, _ Category:=RExcel Application.MacroOptions Macro:=RNumber, _ Description:=Converts a number to a string with the decimal separators needed by R, _ Category:=RExcel END OF CODE Kind Regards *ADVERTENCIA:** * Este mensaje, su contenido y sus archivos adjuntos son confidenciales. Está exclusivamente dirigido al usuario o usuarios de destino. Si, por un error de envío o transmisión, ha recibido este mensaje y usted no es el destinatario del mismo, por favor, notifique este hecho al remitente. Si usted no es el destinatario final de este mensaje no está autorizado a usar, imprimir, copiar o difundir este mensaje bajo ningún concepto, agradeciéndole que proceda de inmediato a la destrucción del mismo. *DISCLAIMER:** * The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in relation to the contents of this information is strictly prohibited and may be unlawful. Neither the sender nor the represented institution are liable for the correct and complete transmission of the contents of an e-mail, or for its timely receipt. *Jose Luis Gilsanz Gomez* *Tasaciones Hipotecarias - Estadistica* ** *Atisreal España* Maria de Molina,54 28006 Madrid Tel. +34 91 454 96 94 Fax +34 91 782 21 64 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] www.atisreal.es http://www.atisreal.es/ - www.tasacionesh.es http://www.tasacionesh.es/ Tildes ortograficas omitidas intencionadamente por motivos de compatibilidad ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] How to put/get data from/to autofiltered column?
The defaults are that filtering is respected for dataframes, but not for matrices. NAs also should be handled reasonably for dataframes. How missing values are handled iis configureable. Documenations describes how you can change this behavior in RExcel-Options Jens Oehlschlägel wrote: Dear rcom experts, I started enjoying the power of R(D)COM using Excel. I tried to putArray from an autofiltered column and learned that all values are transferred to R, which is fine using the RespectHidden trick from PutDataframe: doing the filtering in R. However, when trying to reversely getArray the unfiltered data from R to the original range, then data is mis-assigned. This seems to happen in the line a.value = Matrix in ArrayToSheet. What is the recommended way to put/get data from/to autofiltered column? Intuitively I would think to transfer only non-filtered cells to an VBA-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 at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
[Rcom-l] Crashes on nonEnglish Windows
Some of out users experienced crashes when trying to transfer dataframes. Finally we found the reason. When converting a boolean value to a string in VBA with Cstr, the resulting value depends on the language (we still do not know all the details). On machine with German WinXP and German 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 a Wiki) at http://rcom.univie.ac.at
Re: [Rcom-l] RExcel Language
I opened the file (USEnglish Windows and USEnglish Excel) and it immediately worked. So I need more information in what happened in the French version of Excel and/or Windows. [EMAIL PROTECTED] wrote: Hi Eric, Ive attached an example Excel file with the data that we were trying to read 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] RExcel Language PutDataframe essentially does a PutArray for each column (= variable) of a dataframe. It does a lot opf strange things to detect dates. So I need more information what the dataframe contained to see why things went wrong. [EMAIL PROTECTED] wrote: Hi there, I recently deployed an RExcel spreasheet to a colleague based in France. We had trouble reading in data to R using Rinterface.Putdataframe command from VBA. After some investigation we realised that the trouble emerged from the fact that Excel was using comma's instead of a decimal point, as is the convention in France. We had more success by using Rinterface.PutArray and it seems to read in the numbers correctly. I guess the problem might occur because dataframes can expect non-numeric fields and there may be some confusion as to whether a value is a text value or a numeric value with a comma for a decimal point. Has anyone else encountered this problem? If so can anyone offer some advice on how to deal with this. We are using R 2.6.1 (French language) and the latest version of the R(D)Com. Regards, Wayne Wayne Jones Statistical Consultant Shell Global Solutions (UK) Shell Technology Centre Thornton, P.O. Box 1, Chester CH1 3SH, United Kingdom *Tel:* +44 (0) 151 373 5977* * *Fax:* +44 (0) 151 373 5384* * *Mobile:* +44 (0) 7896 536026 *Email:* [EMAIL PROTECTED] *Internet:*** www.shell.com/globalsolutions/statisticsandchemometrics /Shell Global Solutions (UK) is a division of Shell Research Limited which has its Registered Office at Shell Centre, London SE1 7NA and is registered in England Wales with No.539964./ ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] RExcel Language
PutDataframe essentially does a PutArray for each column (= variable) of a dataframe. It does a lot opf strange things to detect dates. So I need more information what the dataframe contained to see why things went wrong. [EMAIL PROTECTED] wrote: Hi there, I recently deployed an RExcel spreasheet to a colleague based in France. We had trouble reading in data to R using Rinterface.Putdataframe command from VBA. After some investigation we realised that the trouble emerged from the fact that Excel was using comma's instead of a decimal point, as is the convention in France. We had more success by using Rinterface.PutArray and it seems to read in the numbers correctly. I guess the problem might occur because dataframes can expect non-numeric fields and there may be some confusion as to whether a value is a text value or a numeric value with a comma for a decimal point. Has anyone else encountered this problem? If so can anyone offer some advice on how to deal with this. We are using R 2.6.1 (French language) and the latest version of the R(D)Com. Regards, Wayne Wayne Jones Statistical Consultant Shell Global Solutions (UK) Shell Technology Centre Thornton, P.O. Box 1, Chester CH1 3SH, United Kingdom *Tel:* +44 (0) 151 373 5977* * *Fax:* +44 (0) 151 373 5384* * *Mobile:* +44 (0) 7896 536026 *Email:* [EMAIL PROTECTED] *Internet:*** www.shell.com/globalsolutions/statisticsandchemometrics /Shell Global Solutions (UK) is a division of Shell Research Limited which has its Registered Office at Shell Centre, London SE1 7NA and is registered in England Wales with No.539964./ ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
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 majr changes i the last b6 monsths, and R(D)COM installs as outdated versin of RExcel which currently will creeat some coflicts with the newer version. We will have a new installer in a few weeks. On Feb 7, 2008, at 9:21 AM, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hi Baharak, May I suggest you try a newer version of R. The current verion is 2.6.1 which can be found here http://cran.r-project.org/bin/windows/base/R-2.6.1-win32.exe Also there is a newer version of R(D)Com which can be found here: http://rcom.univie.ac.at/download/current/RSrv250_pl1.exe I have no direct experience with Excel 2007 (yet) but I will need to test R(D)Com on Excel 2007 and Vista in the very near future. Therefore, I would be very interested to hear about your progress. Regards Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ]On Behalf Of Farrokhnia, Baharak Sent: 06 February 2008 19:54 To: rcom-l@mailman.csd.univie.ac.at Subject: [Rcom-l] RSrv200 and Excel 2007 Hello, I installed R-2.4.1-win32.exe successfully. Then I installed RSrv200.exe and I got an error RExcel Addin … was not found. (Unfortunately I don't have the full message at the moment.) I had selected Excel Add-In component during the installation. I have Excel 2007 installed. Which version of Excel does RSrv200 work with? Which version of R(D)COM do I need to get it working with Excel 2007? Thanks, Baharak ___ 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 ___ 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
Re: [Rcom-l] Read Excel data
Run the following code to test it your connection between R and RExcel is OK. Sub DFTest() RInterface.StartRServer RInterface.RRun x-1:10 RInterface.RRun y-10:1 RInterface.GetDataframe data.frame(x,y), Range(A1) RInterface.StopRServer End Sub It this works, more information about your dataframe is needed for debugging. Uma Sitaraman wrote: Hi, Hi, Please find below my R code (in R) Portfolio=read.csv(Z:\\Internal\\R Files\\Portfolio.csv, header=T) Benchmark=read.csv(Z:\\Internal\\R Files\\Benchmark.csv, header=T) save.image(Z:\\Internal\\R Files\\sample) Saved as Sample.R Here's my VBA code: to read dataframe Portfolio and then print it into Excel. For some reason, it gives me the following error: It gives me an error Run-time error 13- Type mismatch and when I try to debug, it stops at line below in the RInterface Module. nrows = REvalReturn(dim( DFname )[1]) + 1. VBA Code: Private Sub CommandButton1_Click() Call RInterface.StartRServer Call RInterface.RRun(setwd(Z:/Internal/R Files)) ChDir Z:/Internal/R Files Call RInterface.RunRFile(sample.R) 'Call RInterface.GetDataframe(Portfolio, Range(Sheet1!A1)) Call RInterface.GetDataframe(data.frame(Portfolio), Range(Sheet1!A1)) Call RInterface.StopRServer End Sub PS: I tried both Lines 6 and 7 (that I found in the mailing list) but both give the same error. I am using R (2.5.1) and RSrv200.exe. Regards, Uma -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Uma Sitaraman Sent: Wednesday, January 23, 2008 9:52 AM To: R (D)COM and RExcel server related issues Subject: RE: [Rcom-l] Read Excel data Hi, I tried that too. It still gives me the same 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 Sitaraman wrote: Hi, I am new to both R and RDcom, and am stuck trying to read excel data using R (through VBA code). I tried out the test code posted in the web (given below) Sub ReadTest() rinterface.StartRServer rinterface.RRun setwd(c:/work/rcomtest) ChDir c:\work\rcomtest rinterface.RunRFile read.R rinterface.StopRServer *rinterface.getdataframe mydat, Range(Sheet1!A1)* End Sub you only can stop the server AFTER you have transferred the data to excel. --- read.R setwd(c:/work/rcomtest) mydat-read.csv(data.txt) --- data.txt xxx1,zzz2 1,2 3,4 5,6 It gives me an error Run-time error 13- Type mismatch and when I try to debug, it stops at line below in the RInterface Module. nrows = REvalReturn(dim( DFname )[1]) + 1. I am using R (2.5.1) and RSrv200.exe. Thanks in advance. Regards, -Uma This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Any views or opinions presented are solely those of the author and do not necessarily represent those of Amba Holdings Inc., and/or its affiliates. Important additional terms relating to this email can be obtained at http://www.ambaresearch.com/disclaimer ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] Read Excel data
Uma Sitaraman wrote: Hi, I am new to both R and RDcom, and am stuck trying to read excel data using R (through VBA code). I tried out the test code posted in the web (given below) Sub ReadTest() rinterface.StartRServer rinterface.RRun setwd(c:/work/rcomtest) ChDir c:\work\rcomtest rinterface.RunRFile read.R rinterface.StopRServer *rinterface.getdataframe mydat, Range(Sheet1!A1)* End Sub you only can stop the server AFTER you have transferred the data to excel. --- read.R setwd(c:/work/rcomtest) mydat-read.csv(data.txt) --- data.txt xxx1,zzz2 1,2 3,4 5,6 It gives me an error “Run-time error 13- Type mismatch” and when I try to debug, it stops at line below in the RInterface Module. nrows = REvalReturn(dim( DFname )[1]) + 1. I am using R (2.5.1) and RSrv200.exe. Thanks in advance. Regards, -Uma This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Any views or opinions presented are solely those of the author and do not necessarily represent those of Amba Holdings Inc., and/or its affiliates. Important additional terms relating to this email can be obtained at http://www.ambaresearch.com/disclaimer ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
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 Rinterface.GetArray(variable, Range(sheet1!A(num))) But it dose not work. Any thought on it? Many thanks, Yaning Zhang ___ 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 ___ 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
Re: [Rcom-l] Put R valur into Execl Range
mynum=Rinterface.GetArrayToVBA(mynum) Rinterface.GetArray(variable, Range(Sheet1!A CStr(mynum)) And you shoud definitely read a good book about VBA programming. I highly recommend John Walkenbachs Excel Power Programming You have to get num into VBA with, say, RInterface.GetArrayToVBA if you assignt his to a VBA variable numvba then you can do Yaning Zhang wrote: Thank you for your reply. I am afraid I am not sure I totally understand what you mean. For the string functions. Do you mean the following method? Dim mynum As String Thank you. -Original Message- 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 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 Rinterface.GetArray(variable, Range(sheet1!A(num))) But it dose not work. Any thought on it? Many thanks, Yaning Zhang ___ 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 ___ 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 ___ 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 ___ 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
Re: [Rcom-l] Call rinterface.RRun(Source(ThisWorkbook.Path
ThisWorkbook.Path gives the path in Windows notation, sngle backslashes. This needs to be converted to the representation(s) indicated by Julien. Julien Vanwinsberghe wrote: Hi, In addition, be careful with the source R function, all the folder separators '\' characters must be replaced by '\\' or '/'. Regards, Julien Vanwinsberghe Yaning Zhang a écrit : Hi, if you would like to run R script from a file, maybe you can try Call Rinterface.RunRFile -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Felipe Carrillo Sent: Monday, December 17, 2007 3:35 PM To: rcom-l@mailman.csd.univie.ac.at Subject: Re: [Rcom-l] Call rinterface.RRun(Source(ThisWorkbook.Path My R script and my workbook reside on my desktop. When I try to run my script through the macro nothing happens. the code below seems to be correct though. Call rinterface.RRun(source( ThisWorkbook.Path \temp.r)) Any ideas anybody? --- Prokaj Vilmos [EMAIL PROTECTED] wrote: You probably wanted to write Call rinterface.RRun(source( ThisWorkbook.Path \temp.r)) In VBA stands for inside a string Vilmos Prokaj Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs ___ 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 ___ 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 Felipe D. Carrillo Fishery Biologist US Fish Wildlife Service California, USA Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ ___ 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 ___ 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 ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] Macro RExcel help
Please use rcom, and single step through your VBA code suing F8 in the VBE environment. This way, cou can see at which stpe the error is introduced. Yaning Zhang wrote: Hello, thank you very much for your e-mail, and I paste my codes as following. It works in R, but there is an Rerror when I call it from VBA. Could you please give me some advice? Many thanks Sub Rreg() Call Rinterface.StartRServer Call Rinterface.RunRFile(C:\Documents and Settings\Y\Desktop\function) Call Rinterface.RRun( variableSEN_gbl - devar(tblLiquidity2,'SEN_gbl',3,2,10)) Call Rinterface.RRun( variablefquamsci - deres(tblPrices,'DEV_MSCI')) Call Rinterface.RRun( data- do.call(cbind, sapply(ls(pat='variable'), get))) Call Rinterface.RRun( lm - lm(variablefquamsci~., data=data)) Call Rinterface.GetArray(lm$coefficient, Range(Rsheet!B1)) End Sub -Original 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 Either one of Call Rinterface.RRun (SEN_gbl-devar(tblLiquidity2, SEN_gbl,3,2,10)) Call Rinterface.RRun (SEN_gbl-devar(tblLiquidity2, 'SEN_gbl',3,2,10)) should work. Yaning Zhang wrote: *Hello everyone,* *I am a new user of RExcel and I would like to call R function from Excel with the Macro code. After start the R server, I first execute some codes in a file called function. Then I would like to call the function devar I defined previously. But the error message comes out as compile error: syntax error for *SEN_gbl. Could anyone please give me some advice? ... Call Rinterface.RunRFile (C:\Documents and Settings\Desktop\function) Call Rinterface.RRun (SEN_gbl-devar(tblLiquidity2, SEN_gbl,3,2,10)) Thanks regards, Yaning Zhang ___ 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 ___ 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
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 supply more examples right know, but this peculiarity has hit me a few times. Lindsay, Dwayne wrote: Hello Charilaos- I admit that using rcom commands to create other objects are rather confusing. My general premise is this: comGetProperty and comSetProperty, are used for property events. However, comInvoke is used for methods and objects. In theory, it's pretty simple, but how does one tell the difference between a property versus a method using: comGetObjectInfo...well one cannot. So, to get around this issue I use the Help menu item from the VBA editor window: Help Microsoft Visual Basic Help Microsoft Excel Visual Basic References. Here you will find each parameter that can be manipulate via rcom; it clearly indicates which are properties, methods, objects and event etc. This has proven most helpful to me as I use rcom to dump my subsequent results into Excel, PowerPoint, Word, or Outlook. Also, I use the following code to better view the parameters that comGetObjectInfo() returns: This allows you to view parameters in a more efficient manner jnk1-comGetObjectInfo(wb) info.jnk-matrix(jnk1,nrow=length(jnk1),ncol=4,byrow=T) de(info.jnk) Also, here is some code written explicitly for Excel, I hope this helps! #Create Excel Object excel-comCreateObject(Excel.Application) comSetProperty(excel,Visible,T) comSetProperty(excel, SheetsInNewWorkbook, 1) wb - comGetProperty(excel, Workbooks) wb - comInvoke(wb, Add) #Change the name of a specific worksheet comSetProperty( comGetProperty(wb,Worksheets,1), Name,Requested Asset Information) #Select a specfic sheet sheet-comGetProperty( comGetProperty(wb,Sheets), Item,1) comInvoke(sheet,Activate) #Determine last column of header rows for FONT manipulation last.excel.col-paste(c(LETTERS)[dim(asset.tmp)[2]],'1',sep='') r2-comGetProperty(sheet,Range,A1,last.excel.col) comSetProperty(r2,Value,names(dcc.asset.list)) #Now, Bold the Text. comSetProperty( comGetProperty( comGetProperty(r2,CurrentRegion), Font), Bold,T) #Then, increase the font to: 14 comSetProperty( comGetProperty( comGetProperty(r2,CurrentRegion), Font), Size,14) #Now, Autofilter the column headings. comSetProperty(r2,Autofilter,T) #Determine last row for FONT manipulation last.excel.row2-paste(c(LETTERS)[dim(asset.tmp)[2]], dim(asset.tmp)[1]+1, sep='') r3-comGetProperty(sheet,Range,A2,last.excel.row2) projects-as.matrix(asset.tmp) comSetProperty(r3,Value,projects[1:nrow(asset.tmp),]) #Now, Autofit columns excel.col1-paste('A:',c(LETTERS)[dim(asset.tmp)[2]],sep='') r4-comSetProperty( comGetProperty(sheet,Columns,excel.col1), Autofit,T) #Now, Center align the Text. comSetProperty( comGetProperty(r2,CurrentRegion), HorizontalAlignment,3) #Finally, save workbook to appropriate location comInvoke( wb, SaveAs, paste('c:/temp/Assets/',my.client,'/',my.dow.code,'/', 'Asset Location(s) ',c.month, '-',c.year2,'.xls',sep='') ) comInvoke(wb,Close) comInvoke(excel,Close) Thanks, and good luck! D- -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Charilaos Skiadas Sent: Wednesday, November 14, 2007 6:43 AM To: R ((D))COM and RExcel server related issues Subject: [Rcom-l] Resources for calling Excel from R Let me try this again: Hello all, I'm new to rcom, and my focus is to access Excel from R. For instance, I would like to attempt to read the current spreadsheet. The problem I am running into is how to find out the proper calls. I started with looking at the examples in comGetProperty, and in particular managed to get the following call working: r - comGetProperty(ws,Range,A1,B4) My question really is: How could I have figured out the syntax if noone told me about it? What I tried is looking at: comGetObjectInfo(ws) The output from that is pretty chaotic, so then I tried: sort(names(comGetObjectInfo(ws))) This would show me that one of my options there is Range, but
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 string argument then you need retval-comInvoke(v,PL) Gyula Gulyas wrote: I am running the latest version of rcom and also R 2.6. I have a C++ COM dll that I have been referencing easily from VBA with no problems. COM object has a function in the general function form: myfunction(input as string,returnvalue as long) as long so in R: library(rcom) v-comCreateObject(comdll) i-comGetObjectInfo(v) str(i) # all ok I get function list v$myfunction(PL,retval) R returns: Error in comInvoke(handle, ..FUN, ...) : object retval not found How can I initialize the return value to be a long type? Is there any special way R handles pointers? - I refer here passing by value or by reference. Thanks for any pointers...(no pun intended..;-) ) Gyula __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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 ___ 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
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 instructions. [EMAIL PROTECTED] wrote: Hi, I am new to Rexcel. I am trying to bring 'R' to the foreground, which to my belief should allow greater interaction between 'R' and Excel. To enable foreground, I went to R Console and loaded the 'rcom' package. Next I open MS-Excel and on Rexcel menu select Set R Server. However, the foregound option does not highlight. How to hgihglight this option ? Could there be something I am missing? Any solutions to this problem would be great help Thanks in advance Sumit ___ 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 ___ 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
Re: [Rcom-l] rcom comInvoke #2
This is more than I can answer, now Thomas has to jump in. Gyula Gulyas wrote: it still does not work, and I think the syntax you gave is not correct either. i tried this: retval-0 x-comInvoke(v,myfunction,PL,retval) myfunction returns a long (actually true or false) that simply indicates that things worked ok or not. (in this case x will have that value). the retval is the second argument to the function that is being modified (in fact I pass it with a 0 and expect it to be changed by the function (so it's a method in a strict sense)). I understand that R will not simply allow me to send retval by reference (which I think I need). In R it will become a 'local variable' to myfunction. Is there a way to send retval by reference (as it is modified by the COM dll)? The above call seems to work, but of course retval on the R side will not change...:-( (still shows up as 0) Thanks for your patience! Gyula __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] Time Series Problem
What happens when you run these commands in RGui from the command line? Wayne Aldo Gavioli wrote: Hello all - I'm trying to plot Time-Series data but I'm having a problem with my graph and I can't seem to locate the problem at all - I was wondering if someone could look at the following two lines of code and see what's wrong. PCContribution is the name of the array of data that's being imported from Excel into R - it's 2 columns by 27 rows of data, as is indicated in the first line of code. When I run these two lines of code, the graph pops up and all the axes are labeled correctly, but no lines of data show up on the graph. Call Rinterface.RRun(PCMatrix-ts(matrix(PCContribution, ncol=2, nrow=27, byrow=FALSE), start=1984, end=1985)) Call Rinterface.RRun(plot((PCMatrix), plot.type = 'single', lty=1:2, xlab = 'Time', ylab = 'PC Contribution', main = 'Change in PC Contribution Over Time')) The weird thing is that it seemed to work one minute, but then when I tested it again 5 minutes later it didn't, and I don't think I hit anything or did anything differently. I checked in R, and when I look up package ts, it says the package is there, but it also says: Warning message: package 'ts' has been merged into 'stats' Does that have anything to do with the problem - did I mistakenly do something that moved the location of ts, or no? Wayne ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] VBA Code Issue
Single quotes is a solution, the other solution is double double quotes, like Call Rinterface.RRun(testing-plot((PCMatrix), plot.type = single)) Wollkind, Steven wrote: You can't put quotes within quotes. Try single quotes in the R code. Steve Steve Wollkind Geode Capital Management, LLC 1 Post Office Square / 28th Floor / Boston, MA 02109 [EMAIL PROTECTED] Tel: (617) 392-8991 Fax: (617) 476-6389 This e-mail, and any attachments hereto, are intended for use by the addressee(s) only and may contain information that is (i) confidential information of Geode Capital Management, LLC and/or its affiliates, and/or (ii) proprietary information of Geode Capital Management, LLC and/or its affiliates. If you are not the intended recipient of this e-mail, or if you have otherwise received this e-mail in error, please immediately notify me by telephone (you may call collect), or by e-mail, and please permanently delete the original, any print outs and any copies of the foregoing. Any dissemination, distribution or copying of this e-mail is strictly prohibited. - Original Message - From: [EMAIL PROTECTED] [EMAIL PROTECTED] To: R (D)COM and RExcel server related issues rcom-l@mailman.csd.univie.ac.at Sent: Mon Sep 24 18:15:42 2007 Subject: [Rcom-l] VBA Code Issue Hello all - I'm having a reoccuring (and very frustrating) problem with trying to program some RExcel Code in VBA. Whenever I need to specify some additional part of R code in quotation marks, VBA goes wild and won't accept it, as it always gives the following error: Compile error: Expected: list separator or ) For example, in the following 3 lines of code, I'm trying to take some data from Excel, import into R under the array name PCContribution, convert it to a matrix, and then plot it. Seems simple enough, right? When I get to the third line/entry of code below though, the above error always comes up and it highlights the word single when it presents the error. Call Rinterface.PutArray(PCContribution, Range(Graphs!A1:C20), WithRownames:=False, WithColNames:=False) Call Rinterface.RRun(PCMatrix-ts(matrix(PCContribution, ncol=2, nrow=27, byrow=FALSE), start =c(1983, 3), frequency = 3)) Call Rinterface.RRun(testing-plot((PCMatrix), plot.type = single)) Can anyone help? It's really frustrating because I know the code is right and should produce the correct graph - it's just the syntax with the quotation marks, I guess, that doesn't work in VBA but is what is required in R. Can anyone help? ___ 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 ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] RExcel.xla
http://learnserver.csd.univie.ac.at/rcomwiki/doku.php?id=general_problems_and_solutions Giorgio Bocchi wrote: sorry but I cannot find anything in Wiki related to this problem can someone please give me more specific directions to fix this issue many thanks Giorgio Erich Neuwirth [EMAIL PROTECTED] ivie.ac.at To Sent by: R (D)COM and RExcel server related [EMAIL PROTECTED] issues lman.csd.univie.ac rcom-l@mailman.csd.univie.ac.at .at cc Subject 13/04/2007 22:20 Re: [Rcom-l] RExcel.xla Please respond to R \(D\)COM and RExcel server related issues [EMAIL PROTECTED] d.univie.ac.at Please read the wiki on rcom.univie.ac.at There you will find a solution for the problem (which also has been poster a few times n this list already). Giorgio Bocchi wrote: Hi apologies if my issue is not addressed to the correct forum. If so, please kindly point me to the correct one. I have installed R 2.4.1 and D(COM)Server. Once opened the Excel file RExcelAddinInstall.xls and run Install RExcel the following Microsoft Visual Basic is returned Run-time error '5' Invalid procedure call or argument In debug the error generates from Sub RemoveRMenu() at the command CommandBars(1).Controls(RExcel).Delete Maybe I'm doing something wrong or missing a simple fix but cannot get around it Any help will be much appreciated thanks Giorgio --- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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 --- This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and delete this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden. Please refer to http://www.db.com/en/content/eu_disclosures.htm for additional EU corporate and regulatory disclosures. ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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
Re: [Rcom-l] Error in R matlab connection
I do not have matlab, so I do not know the mechanism of creatinf a COM object in matlab. I notice that you are using Eval for calls with reaturn values AND for calls without return values. The R COM object has 2 methods, Evaluate and EvaluateNoRerurn You should use the second one for assigments like your g- Mehmet Tan wrote: Hi, Maybe the answer to this question has been given before but I could not figure out how to search the threads in the list. My question is about the error message in matlab, Invoke Error, Dispatch Exception: Object is static; operation not allowed What I do is below: [s,m] = openR; % connection is established correctly r = evalR('ls()') r = [] %the connection works and there is no variables defined in R yet evalR('library(ordpcalg)') % I load a library evalR('g - randomDAG(10,0.2)') % I call a function that is in ordpcalg package loaded above r = evalR('ls()') r = 'g' % randomDAG works! evalR('g - randomDAG2(10,0.2,4,0.5)') ??? Error using == evalR Problem evaluating command print(g2 - randomDAG2(10,0.2,4,0.5)). Invoke Error, Dispatch Exception: Object is static; operation not allowed % I call randomDAG2 (another function in ordpcalg) but is gives the above error. The function call is correct and works in RGui. I am working on windows and using R-2.5.1 and Matlab 7.0.0.19920(R14). What can the problem be? Thanks, Mehmet -- Mehmet ___ 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, Didactic Center for Computer Science University of Vienna Visit our SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-9394 ___ 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
Re: [Rcom-l] rinterface RRun-RRunFile
in r prograns, you need single forward slashes as path separators. you also might use double backslashes. so the double forward slashes are your problem. my example showed you which slashes to use where. Felipe Carrillo wrote: Hi all: I am still having troubles running r files through excel macros. I tried to run the example supplied and tried to adapt it to my file path and still didn't work. Could anybody take a few minutes to put together an example with the info below? The path to my data is: C:/Documents and Settings/Owner/Desktop/R-Software/chinook.txt The path to my r file is: C:/Documents and Settings/fcarrillo/Desktop/R-Software/Test.r The Test.r file has three lines of code: line 1 chinook - read.table(C://Documents and Settings//fcarrillo//Desktop//R-Software//chinook.txt,header=T,sep=\t) line 2 chinook$IDDate - as.Date(chinook$IDDate, %m/%d/%Y) line 3 qplot(IDDate,Fry, data=chinook, geom=line) Thanks and I would really appreciate it Felipe D. Carrillo Fishery Biologist US Fish Wildlife Service Red Bluff, California 96080 Park yourself in front of a world of choices in alternative vehicles. Visit the Yahoo! Auto Green Center. http://autos.yahoo.com/green_center/ ___ 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 SunSITE at http://sunsite.univie.ac.at Phone: +43-1-4277-39464 Fax: +43-1-4277-39459 ___ 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