Hello I am new to RExcel and I would like to run a source code form the
excel worksheet. I would like to run the following code
source("C:\\Quantil Aplicativos\\Genercauca\\BackwardSelectionNC.r")
from the excel wroksheet. Does anybody know how to do this?
Thank you
Felipe Parra
[[alternative HTML version deleted]]
Hello, I am trying to use RExcel and I would like to know if it is possible
to use in excel the following function I made for R
Pron = function(path="C:\\Quantil Aplicativos\\Genercauca\\V5\\"){
library(timeSeries)
library(maSigPro)
### CARGAR FUNCIONES
source(paste(path,"\\fUtilidades\\BackwardSelectionNC.r",sep<file://futilidades//BackwardSelectionNC.r%22,sep>
=""))
source(paste(path,"\\fUtilidades\\CriteriosDeComparacion.r",sep<file://futilidades//CriteriosDeComparacion.r%22,sep>
=""))
dataTSORG<-read.csv('entrada.csv', header = TRUE, sep =
",", quote="\"",
dec=".",fill = TRUE, comment.char="")
dataTSORG = ts(dataTSORG, start=c(1950,1), frequency=12)
dataTSORG = as.timeSeries(dataTSORG)
X = prcomp(dataTSORG[,2:40])$x
return(X)
}
Does somebody know if its possible? and if so how can I do it?
Thank you
Felipe Parra
[[alternative HTML version deleted]]
Hi,
For RExcel I would suggest subscribing;
http://mailman.csd.univie.ac.at/listinfo/rcom-l
They have a website on;
http://rcom.univie.ac.at/
B.R.
Stephen L
----- Original Message ----
From: Luis Felipe Parra <felipe.parra at quantil.com.co>
To: r-help <r-help at r-project.org>
Sent: Mon, November 22, 2010 8:11:39 PM
Subject: [R] Rexcel
Hello I am new to RExcel and I would like to run a source code form the
excel worksheet. I would like to run the following code
source("C:\\Quantil Aplicativos\\Genercauca\\BackwardSelectionNC.r")
from the excel wroksheet. Does anybody know how to do this?
Thank you
Felipe Parra
[[alternative HTML version deleted]]
______________________________________________
R-help at 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.
Em 22/11/2010 10:11, Luis Felipe Parra escreveu:> Hello I am new to RExcel and I would like to run a source code form the > excel worksheet. I would like to run the following code > > source("C:\\Quantil Aplicativos\\Genercauca\\BackwardSelectionNC.r") > > from the excel wroksheet. Does anybody know how to do this? > > Thank you >Felipe, Look at the section "Startup" in the RExcel help. In a nutshell, if you want the code to run immediately at the loading of the spreadsheet, create a workbook called "RCode" and put your source there. Other options are available. See the docs. -- Cesar Rabak
a) RExcel has its own mailing list (as the documentation tell you). Please post RExcel related questions to the mailing list accessible at rcom.univie.ac.at b) For running code at startup, you have to create a worksheet (not a workbook) named RCode in your workbook. On 11/22/2010 7:15 PM, csrabak wrote:> Em 22/11/2010 10:11, Luis Felipe Parra escreveu: >> Hello I am new to RExcel and I would like to run a source code form the >> excel worksheet. I would like to run the following code >> >> source("C:\\Quantil Aplicativos\\Genercauca\\BackwardSelectionNC.r") >> >> from the excel wroksheet. Does anybody know how to do this? >> >> Thank you >> > Felipe, > > Look at the section "Startup" in the RExcel help. In a nutshell, if you > want the code to run immediately at the loading of the spreadsheet, > create a workbook called "RCode" and put your source there. > > Other options are available. See the docs. > > -- > Cesar Rabak > > ______________________________________________ > R-help at 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. >