Re: [R] Rexcel path problem
Jorge,
This looks like an R on Windows problem, it is unrelated to VBA.
You have the statement
(source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home
models\toto.R'))
which is invalid R. You need to use either forward slashes or
double-back-slashes in R commands.
See the R for Windows FAQ 2.16.
Further RCOM questions should be addressed to the rcom list. You can sign
up at
rcom.univie.ac.at
Rich
On Fri, Apr 1, 2011 at 10:12 AM, Jorge Nieves jorge.nie...@moorecap.comwrote:
Hi,
I am running a test to call an R script with in excel using VBA. My VBA
code is shown bellow. The middle section of this mail also includes the
content of my Rscript. The bottom part shows the error message form the
R console.
It seems that Excel is opening the R console without any problems.
The problem I am seeing is that Rinterface.RRun instruction is
interpreting the \T part of the path as an R command. It does not
recognize the X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home
models\ as a one single string, or path.
Any ideas how can I fix the problem?
Thanks ,'
Jorge
VB code
Sub tester()
Rinterface.StartRServer
Rinterface.RRun
(source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home
models\toto.R'))
Rinterface.StopRServer
End Sub
R cript code toto.R
path = getwd()
setwd(path)
a = 5
b=5
x = matrix(rnorm(a*b),a,b)
a = 5
b=5
y = matrix(rnorm(a*b),a,b)
z = x %*% y
savefile = paste(path,/,testresults.csv,sep=)
write.csv(z, file = savefile)
Rconsole message
Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.
Loading required package: rcom
Loading required package: rscproxy
Error: '\T' is an unrecognized escape in character string starting
source('X:\T
Jorge Nieves
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide
http://www.R-project.org/posting-guide.htmlhttp://www.r-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] Rexcel path problem
On 01-04-2011, at 16:12, Jorge Nieves wrote:
Hi,
I am running a test to call an R script with in excel using VBA. My VBA
code is shown bellow. The middle section of this mail also includes the
content of my Rscript. The bottom part shows the error message form the
R console.
It seems that Excel is opening the R console without any problems.
The problem I am seeing is that Rinterface.RRun instruction is
interpreting the \T part of the path as an R command. It does not
recognize the X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home
models\ as a one single string, or path.
Any ideas how can I fix the problem?
Thanks ,'
Jorge
VB code
Sub tester()
Rinterface.StartRServer
Rinterface.RRun
(source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home
models\toto.R'))
Rinterface.StopRServer
End Sub
R cript code toto.R
path = getwd()
setwd(path)
a = 5
b=5
x = matrix(rnorm(a*b),a,b)
a = 5
b=5
y = matrix(rnorm(a*b),a,b)
z = x %*% y
savefile = paste(path,/,testresults.csv,sep=)
write.csv(z, file = savefile)
Rconsole message
Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.
Loading required package: rcom
Loading required package: rscproxy
Error: '\T' is an unrecognized escape in character string starting
source('X:\T
R is just telling you that it doesn't recognize \T as a valid escape sequence
in a character string.
See R for Windows FAQ 2.16 and 5.1.
Use \\ instead of a single \ as path separator or use the forward slash /.
Berend
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] Rexcel path problem
Use / instead of \ in the path.
---
Jeff Newmiller The . . Go Live...
DCN:jdnew...@dcn.davis.ca.us Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---
Sent from my phone. Please excuse my brevity.
Jorge Nieves jorge.nie...@moorecap.com wrote:
Hi, I am running a test to call an R script with in excel using VBA. My VBA
code is shown bellow. The middle section of this mail also includes the content
of my Rscript. The bottom part shows the error message form the R console. It
seems that Excel is opening the R console without any problems. The problem I
am seeing is that Rinterface.RRun instruction is interpreting the \T part of
the path as an R command. It does not recognize the
X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\ as a one single
string, or path. Any ideas how can I fix the problem? Thanks ,' Jorge VB code
Sub tester() Rinterface.StartRServer Rinterface.RRun
(source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home models\toto.R'))
Rinterface.StopRServer End Sub R cript code toto.R path = getwd() setwd(path)
a = 5 b=5 x = matrix(rnorm(a*b),a,b) a = 5 b=5 y = matrix(rnorm(a*b),a,b) z = x
%*% y savefile = paste(path,/,testresults.csv,sep=) write.csv(z, file =
savefile) Rconsole messa
ge Type
'demo()' for some demos, 'help()' for on-line help, or 'help.start()' for an
HTML browser interface to help. Type 'q()' to quit R. Loading required package:
rcom Loading required package: rscproxy Error: '\T' is an unrecognized escape
in character string starting source('X:\T Jorge Nieves
[[alternative HTML version
deleted]]_
R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
Re: [R] Rexcel path problem
Jorge:
You can run save your scripts in the same folder where your wokbook is and run
it like this:
Sub Scatter()
Call rinterface.StartRServer
'Put the dataframe into R
Call rinterface.PutDataframe(scatter, DownRightFrom(Range(RData!A1)),
WithRowNames:=False)
Call rinterface.RRun(attach(scatter))
'Run the RScatter script
rinterface.RunRFile ThisWorkbook.Path \RScatter.r
Call rinterface.StopRServer
End Sub
I
Felipe D. Carrillo
Supervisory Fishery Biologist
Department of the Interior
US Fish Wildlife Service
California, USA
http://www.fws.gov/redbluff/rbdd_jsmp.aspx
- Original Message
From: Jorge Nieves jorge.nie...@moorecap.com
To: r-h...@stat.math.ethz.ch
Sent: Fri, April 1, 2011 7:12:39 AM
Subject: [R] Rexcel path problem
Hi,
I am running a test to call an R script with in excel using VBA. My VBA
code is shown bellow. The middle section of this mail also includes the
content of my Rscript. The bottom part shows the error message form the
R console.
It seems that Excel is opening the R console without any problems.
The problem I am seeing is that Rinterface.RRun instruction is
interpreting the \T part of the path as an R command. It does not
recognize the X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home
models\ as a one single string, or path.
Any ideas how can I fix the problem?
Thanks ,'
Jorge
VB code
Sub tester()
Rinterface.StartRServer
Rinterface.RRun
(source('X:\Trading\Energy\JorgeSpace\TMPholder\cpixe\home
models\toto.R'))
Rinterface.StopRServer
End Sub
R cript code toto.R
path = getwd()
setwd(path)
a = 5
b=5
x = matrix(rnorm(a*b),a,b)
a = 5
b=5
y = matrix(rnorm(a*b),a,b)
z = x %*% y
savefile = paste(path,/,testresults.csv,sep=)
write.csv(z, file = savefile)
Rconsole message
Type 'demo()' for some demos, 'help()' for on-line help, or
'help.start()' for an HTML browser interface to help.
Type 'q()' to quit R.
Loading required package: rcom
Loading required package: rscproxy
Error: '\T' is an unrecognized escape in character string starting
source('X:\T
Jorge Nieves
[[alternative HTML version deleted]]
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
