RE: [Fwd: Re: [Rcom-l] Building R(D)Com Web Application experiences]

Hi Thomas, THanks for the help in retrieving a server under shared use. In the VB code example: RServerManager.ServerPool.Item("MyR").Server.EvaluateNoReturn("plot(x)") Is this retrieving a server for shared use or is it doing something different? Regards, Wayne http://rcom.univie.ac

RE: [Rcom-l] Building R(D)Com Web Application experiences

Hi Thomas & fellow R(D)Com users, Thanks for the excellent suggestion of using RserverManager. This would seem to be exactly what I need! I have managed to get an example in VBA working (See VBA code at bottom of email). However, when I try to run a corresponding example using .NET with C# I

[Rcom-l] Building R(D)Com Web Application experiences

Dear fellow R(D)Com Users, I am looking in to porting an application I have written in RExcel, R and rcom to a web based app. After some research I am currently favouring the approach of using ASP.Net with C# to build the website and connect to R using R(D)Com using the StatConnectorClass. I

RE: [Rcom-l] Update to R2.8.0: Can't copy Excel Worksheet

Hi Christian, There are some big changes to R in version R 2.8.0. Apparently some of the dll files in the core R distribution have changed and rcom hasnt been updated to accomodate these yet (Erich, Thomas correct me if I am wrong). I would revert back to R.7.2 for now. Regards, Wayne --

RE: [Rcom-l] PutDataFrame

Are you sure Rexcel has been installed correctly? Which version of Excel are you using? Try the following: Navigate to "Program Files">RExcel->xls and double click on ActivateRExcel.bat -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Fabien Rinaldi Sent:

RE: [Rcom-l] PutDataFrame

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

RE: [Rcom-l] Help for a Beginner please

Hi there Lynne, Is there a specific reason why you are building this application using VB.Net or R(D)Com for that matter? I it to build an application for a client? There is a package available from CRAN called "RODBC" which allows R to directly connect to odbc data sources! You can set your or

RE: [Rcom-l] Internet proxies

Hi there Michal, I have also come across this issue. There are a few potential fixes depending on how you are using R(D)Com. 1) When you install R choose custom instalation and select the --internet 2 option! This will use --internet2 option everytime you start R. Erich or Thomas can you co

RE: [Rcom-l] Bug Report

Hi Christian, I have also come across this problem. I know Erich is aware of this issue and he has advised me that this will be ammended in future releases of RExcel. In the meantime I suggest you use short filenames and worksheet names. Regards, Wayne -Original Message- From: [EM

RE: [Rcom-l] Sourcing R code from VBA

It could be the fact that you are using the xlsreadwrite package. This may well be interfering with RExcel. Try it without "write.xls(totDat, "C:\\AAA.xls",colNames = FALSE,sheet = 1,from = 1,rowNames=NA ) ;" and see if it works You can use RExcel to write to an Excel spreadsheet anyhow! Regar

RE: [Rcom-l] Sourcing R code from VBA

Try Call RInterface.RunRFile("C:/Subodh/Prog/temprr.txt") or Call RInterface.RunRFile("C:\Subodh\Prog\temprr.txt") instead of Call RInterface.RunRFile("C:\\Subodh\\Prog\\temprr.txt") Regards Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Santosh

RE: [Rcom-l] Option to start RExcel in foreground and background

Hi Ryan, Im not sure if this is really allowed(!) but the following VBA code selects the local background server option: Call SaveSetting("RExcel", "Server", "ServerType", 3) Make sure R server is not running before executing this command. To resume with local foreground server use: Cal

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

Hi fellow RExcel users, In a similar vain to the thread for detecting if RExcel is installed I thought I would share some simple VBA code. We have an RExcel application which will be in use by several different versions of Excel (2000,2003,2007) and thus RExcel. Rather than write different v

RE: [Rcom-l] RAndFriendsSetup2070V20-5 issues

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

RE: [Rcom-l] RAndFriendsSetup2070V20-5 issues

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]

RE: [Rcom-l] RAndFriendsSetup2070V20-5 issues

Hi Erich, I have had a little more time to analyse why the RExcel examples are not working correctly. It seems to be associated with the worksheet functions as opposed to the macro functions. Im getting errors in the "interactive graphics" demo because the variable x is not being read in c

RE: [Rcom-l] RAndFriendsSetup2070V20-5 issues

Hi Erich, No I was running the demo files one by one. Regards Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirth Sent: 29 May 2008 14:05 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] RAndFriendsSetup2070V20-5 issue

[Rcom-l] RAndFriendsSetup2070V20-5 issues

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

RE: what is RAndFriends?? Re: [Rcom-l] New RAndFriends

You can find more info about this on the rcom Wiki. http://learnserver.csd.univie.ac.at/rcomwiki/ RandFriends contains R, RExcel, R Commander all neccessary support files and packages for easy installing. Its all you need to get started using RExcel and R(D)Com. Regards Wayne -Origi

RE: [Rcom-l] New RAndFriends

Hi Erich and Thomas, Thats excellent news. Your work on R(D)Com and RExcel is very much appreciated. We are scheduled to move to Vista later on this year (around October). Regards, Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirth S

RE: [Rcom-l] New RAndFriends

Yes Erich problem only occurs on Vista, RandFriends works fine on XP. This error message would not matter if it was only to be used for my own purposes. However, here at Shell we use RandFriends to deploy applications to different people across the business. Most users have lockdown PCs which

RE: [Rcom-l] New RAndFriends

Hi Erich, I followed your instructions and the installation successfully found the correct version of Excel and all RExcel examples worked fine. Thanks. I still get the following error message: > C\Windows\System32\stdole2.tlb > Unable to register the type library: RegisterTypeLib failed;

RE: [Rcom-l] New RAndFriends

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 comp

RE: [Rcom-l] New RAndFriends

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 li

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

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

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

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 searchi

[Rcom-l] Unable to change R Server Config

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 fo

[Rcom-l] RExcel Language

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 decim

RE: [Rcom-l] RExcel Background Server Config & library(tkrplot)

Hi Vilmos, THanks for your help. The code works fine and I can now run my application using the background server. Thanks Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Prokaj Vilmos Sent: 14 February 2008 12:52 To: R (D)COM and RExcel server

[Rcom-l] RExcel Background Server Config & library(tkrplot)

Hi RExcel users, I am exploring the package tkrplot. This allows you to build interactive plots using tctlk. >From Excel I am running the following source using "Rinterface.RunRFile": library(tcltk) library(tkrplot) tt <- tktoplevel() bb<-1 img <-tkrplot(tt, function() plot(1:20,(1:20)^bb))

RE: [Rcom-l] RSrv200 and Excel 2007

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:

RE: [Rcom-l] Example exporting R graph to Powerpoint

Excellent that works!! Thanks for the help. Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirth Sent: 20 November 2007 09:13 To: R (D)COM and RExcel server related issues Subject: Re: [Rcom-l] Example exporting R graph to Powerpoint Th

[Rcom-l] Example exporting R graph to Powerpoint

Hi everyone, Im trying to learn more about using rcom to generate powerpoint presenatations. I have found a few examples on how to do some basic stuff: http://mailman.csd.univie.ac.at/pipermail/rcom-l/2006-December/001363.html http://www.mf.uni-lj.si/ibmi/biostat-center/gradiva/Lajovic_ppti

RE: [Rcom-l] Workaround Time Zone bug RExcel

Hi Erich, Thanks for your very quick response. This should now solve the problem. Has this issue been resolved in the most recent version of R(D)Com? Regards, Wayne -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Erich Neuwirthnks Sent: 16 November 200

RE: [Rcom-l] Workaround Time Zone bug RExcel

Hi Erich, Thanks for the quick reply. I will forward this on to the users who are affected by the problem. However, can you advise me what is the best way to permanently change the RExcel.xla add-in. They seem to have problems saving the changes. Regards Wayne -Original Message-

[Rcom-l] Workaround Time Zone bug RExcel

Hi Everyone, I am being faced with the same bug as as a previous post on the rcom mailing list: see http://mailman.csd.univie.ac.at/pipermail/rcom-l/2006-November/001332.html . Namely, an RExcel application I have deployed is having trouble coping with different time zones. We here at Shell a