t; Subject: Re: [Rcom-l] Background server (RExcelForRCOM.xls)
> To: [EMAIL PROTECTED], "R (D)COM and RExcel server related issues"
>
> Date: Tuesday, December 2, 2008, 8:05 AM
> Felipe Carrillo schrieb:
> > Hi Erich,Thomas:
> > My background server still doesn
[EMAIL PROTECTED], "R (D)COM and RExcel server related issues"
>
> Date: Tuesday, December 2, 2008, 8:05 AM
> Felipe Carrillo schrieb:
> > Hi Erich,Thomas:
> > My background server still doesn't work. If I
> click on RExcel >> Set R server >> and s
Hi Erich,Thomas:
My background server still doesn't work. If I click on RExcel >> Set R server
>> and select Server type = Background and then click on the command button
below "Save" should be enough to to set the background or do I need to click on
"Configure R server(s)" button and select "T
nd server doesn't work]
> To: "R (D)COM and RExcel server related issues"
>
> Date: Monday, December 1, 2008, 3:02 PM
> Felipe Carrillo schrieb:
> > Ok Thomas. In which order Am I suppossed to install
> the programs? 1.- R 2.- R_Scilab_DCOM3.0-1B5.exe 3.- RExcel
&
nday, December 1, 2008, 1:36 PM
> 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
>
round server doesn't work
> Datum: Mon, 01 Dec 2008 22:19:20 +0100
> Von: Thomas Baier <[EMAIL PROTECTED]>
> An: [EMAIL PROTECTED]
> Referenzen:
> <[EMAIL PROTECTED]>
>
> Felipe,
>
> Felipe Carrillo schrieb:
> > I am trying to run it from an
work
> To: [EMAIL PROTECTED], "R (D)COM and RExcel server related issues"
>
> 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 instruct
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 insta
Erich:
With the latest updates of RExcelInstaller do we still need to download
R (D)COM and rcom separately from Cran or these two packages get installed
with the newer version? Thanks
___
Rcom-l mailing list
Rcom-l@mailman.csd.univie.ac.at
http
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
Nevermind Erich, I deleted the old version completely
along with DCOM and then installed the new version. I
downloaded the old version again and then installed
the new version on top of it so now I have background
server again. I am not sure if this is the right way
but its working fine again.
Fe
Hi Erich:
Everything works fine now with the new version but now
the R console pops up everytime I run the macro. I
wanted to set it to work on the background but I don't
get the option( is grayed out).I followed the
instructions on the sheet by setting the security and
allowing the certificate to
ge here
--- Erich Neuwirth <[EMAIL PROTECTED]>
wrote:
> 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)
> >
>
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 dat
Hi all:
I am trying to import only one row of data into Excel
with a macro and I can't quite get it right.
Sub InsertDataIntoR()
Call RInterface.StartRServer
'The weekly dataframe has 7 rows
Call RInterface.PutDataframe("weekly",
Range("Sheet1!A1:E" & Range("E1").End(xlDown).Row))
Range("J2").selec
Hope this helps:
Sub MyMACRO()
Call rinterface.StartRServer
'Put the dataframe into R
Call rinterface.PutDataframe("dataframeName",
Range("Sheet1!A1:D" & Range("D1").End(xlDown).Row))
Call rinterface.RRun("attach(dataframeName)")
Call rinterface.StopRServer
> I am new to both R and RDcom, and am
7 décembre 2007 21:44
> À : 'R (D)COM and RExcel server related issues'
> Objet : RE: [Rcom-l] Call
> rinterface.RRun("Source(ThisWorkbook.Path &
>
> Julien,
>
> I my .net class I use 4 backslashes when
> referencing a directory
> location.
>
gt; 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]
>
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 pr
Hi:
I can't make the code below work,can someone tell me
what I am missing?
Call rinterface.RRun("source(ThisWorkbook.Path & " \ temp.r")")
Felipe D. Carrillo
Fishery Biologist
US Fish & Wildlife Service
California, USA
_
Hello all:
Using the savePlot function works fine if I want to
display the graph window and then save it into a file.
How can I just save the graph into a file without
seeing the graph window? I am running the R script
from excel.
Call RInterface.StartRServer
'Put the dataframe into R
Call RInterf
Erich:
Thanks a lot, it worked great. Can I also use the same
savePlot function to embed the graph on the worksheet?
Thanks
Erich Neuwirth:
Look at the R function savePlot.
You can run it like
RRun "savePlot(filename='myplot',type='bmp')"
>
>
Felipe Carrill
Hello all:
Just wondering if is at all possible to save one or
more graph windows as GIF or bmp with a macro.
Thanks
Felipe D. Carrillo
Fishery Biologist
US Fish & Wildlife Service
Red Bluff, California 96080
___
ht 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 exampl
e.RunRFile "read.R"
> rinterface.StopRServer
> rinterface.getdataframe "mydat",
> Range("Sheet1!A1")
> End Sub
>
>
> --- read.R
>
> setwd("c:/work/rcomtest")
> mydat<-read.csv("data.txt")
>
>
> ---
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
Settin
: Tuesday, August 14, 2007 1:02 PM
> To: R (D)COM and RExcel server related issues
> Subject: Re: [Rcom-l] Excel Macro
>
> show us your read.table command.
> does it have the fiull path with the right kind of
> backlslahes
> or slashes?
>
> Felipe Carrillo wrote:
ing th R(D)COM server or rcom.
> I suggest you ise rcom,
> then you see what is happening.
>
> you also can switch on debugging in RExcel to see
> what goes wrong.
>
> Felipe Carrillo wrote:
> > # The filename is Test.r
> > chinook <- read.table("C:/
I try to call it like this:
Sub Testing()
Call RInterface.StartRServer
Call RInterface.RunRFile("C:\Documents and
Settings\Owner\Desktop\R-Software\Test.r")
End Sub
--- Erich Neuwirth <[EMAIL PROTECTED]>
wrote:
> show us your read.table command.
> does it have the fiull path with the
;)
End Sub
--- Erich Neuwirth <[EMAIL PROTECTED]>
wrote:
> The script can use all R functions
> for reading data,
> load (for workspaces)
> or read.table or
> read.spss (from package foreign)
>
>
> Felipe Carrillo wrote:
> > Dwayne:
> > Thanks a lot for your
helps and please let if you need a
> little more info.
>
> Also, 'source' is a R-command that I insert into the
> RExcel VBA wrapper.
> Be sure to double up on the: /. For example, R will
> execute:
> source(""C://temp//Capital Tracking Script.txt""
Hi all:
Running the code below in R I am able to create a line
graph. Is there a way to run the same code from an
Excel macro and get the same results?
chinook <- read.table("C:/Documents and
Settings/Owner/Desktop/R-Software/chinook.txt",
header=T,sep="\t")
chinook$IDDate <- as.Date(chinook$ID
t; Please install R-2.5.1 and the newer version of the
> (D)COM server from
>
http://rcom.univie.ac.at/download/current/RSrv250_pl1.exe
>
> If the problems persist, write us again.
>
>
>
> Felipe Carrillo wrote:
> > Hi all: I am new to RCOM and facing some proble
nload/current/RSrv250_pl1.exe
>
> If the problems persist, write us again.
>
>
>
> Felipe Carrillo wrote:
> > Hi all: I am new to RCOM and facing some problems
> on
> > the installation. I got the message below when
> trying
> > to send my worksheet
34 matches
Mail list logo