similar to: How to use R script in VB?

Hello thankful R friends, Can I use iteration (for) or conditional (if) syntax in rexcel using rrun? I've finished coding my program and want to run through Excel. I just want to run such as Call rinterface.RRun("for(i in 1:10){") Call rinterface.RRun("a[i,1]<-i") Call rinterface.RRun("}") But it doesn't work. Any solution or trick to use "for"

Hello, I must tell you once again to address your questions to r-help at r-project.org And since there was no subject line, I've made up one. Your question seems to be a question about excel, and I really can't help you. Maybe someone else can. But if you write.table(etszP) can't you read that file into excel? Rui Barradas Em 22-08-2013 15:57, siddhartha.geddam at eclerx.com

Hello R friends, I've got error message as follows; > > n<-0 > roc<-array(0,c(ti-1,1)) > avgroc<-0 > > for(i in 1:ti-1){ + if(orientation=="in"){ + if(eff_p1[i,1,i]==1 && eff_p1[i,1,ti-1]<1 && ed[i,1]>d[i,1]){ + roc[i,1]<-(1/eff_p1[i,1,ti-1])^(1/(ed[i,1]-d[i,1])) + n<-n+1 + } + } +

Hello, I just installed RExcel but I have some problems. I am writing you the set of commands that I used: > install.packages("RExcelInstaller", "rcom", "rsproxy") > library(rcom) > comRegisterRegistry() > library(RExcelInstaller) > installstatconnDCOM() > installRExcel() But when I select RStart from add-ins I see this written "No R server

Hi community. I'm fairly new to R and have a basic question. When I try to install RExcel with the code: install.packages("RExcelInstaller", "rcom", "rsproxy") I get the message below: Warning in install.packages("RExcelInstaller", "rcom", "rsproxy") : 'lib = "rcom"' is not writable Error in

Hi R-users! I'm trying to create an easy Excel chart using the package RDCOMClient. The following example is working fine: #------------------------------------------------------------------- library(RDCOMClient) xlLocationAsObject <-2 xlXYScatterSmoothNoMarkers <- 73 ex <- COMCreate("Excel.Application") wb <- ex[["Workbooks"]]$Add() sh <-

Muchas gracias, Sergio. Saludos cordiales. Eduardo Freyre -----Mensaje original----- De: miguel.angel.rodriguez.muinos en sergas.es [mailto:miguel.angel.rodriguez.muinos en sergas.es] Enviado el: viernes, 12 de julio de 2013 12:39 Para: efreyre en movistar.es; r-help-es en r-project.org Asunto: RE: [R-es] Conexion excel vba con R y VBasic con R Hola Eduardo. Lo que buscas lo puedes

Buenos días: ¿Hay alguna forma de conectar VBA de Excel con R, de forma que desde Excel se puedan cursar instrucciones de R?, ¿ y V.Basic con R? Gracias anticipadas. Saludos [[alternative HTML version deleted]]

I have a setup with lot's of small files (Maildir), in 4 different volumes and for some reason the volumes are full when they reach 60% usage (as reported by df ). This was ofcourse a bit of a supprise for me .. lots of failed writes, bounced messages and very angry customers. Has anybody on this list seen this before (not the angry customers ;-) ? Regards, =paulv # echo "ls

Hola a todos, Mi nombre es Juanjo. Llevo un tiempo intentado hacer funcionar un programa que necesita de la instalación de RPROJECT y REXCEL. He mirado varias guías e instalado los programas pero obtengo varios errores. El principal es que tras instalar RProject, Rexcel y statcon y al intentar correr esta macro desde Visual Basic… Sub Start() RInterface.StartRServer

I''m happy I''ve succeeded in creating Windows 2003 server guest VM on a xen machine. (if anybody interested in how to, refer to Xen Technical Note V07132006) My further question is: is there a way I can assign a null video device to Windows VM? I want win server keep working, but not its display (implemented on gnome) on console monitor all the time. Joon Woo

I am trying to install lifemetrics to use excel with R. Is there anyone who knows lifemetrics and can help me to install it? -- View this message in context: http://r.789695.n4.nabble.com/PROBLEMS-INSTALLING-LIFEMETRICS-tp4647717.html Sent from the R help mailing list archive at Nabble.com.

> On Mar 1, 2018, at 2:02 PM, Michael Ashton <m.ashton at enduringinvestments.com> wrote: > > Hi - > > For a while I've used RExcel without problems to run a repeating portfolio optimization problem where I solve for a portfolio allocation targeting a particular risk, then solve for a different risk, etc. I call the commands with (e.g.) rinterface.Rrun "(R

Hi, I am using RExcel both at work and at home and am facing a couple of challenges. The one at home is that when using RExcel and trying to run any code that involves changing the working directory, I get the following error. Error in command: setwd("C:\\Raoul\\R\\R Maps_UK Maps_Test\\NUTS_03M_2006_SH\\shape\\data")\n cannot change working directory The one at office is more

Hi - For a while I've used RExcel without problems to run a repeating portfolio optimization problem where I solve for a portfolio allocation targeting a particular risk, then solve for a different risk, etc. I call the commands with (e.g.) rinterface.Rrun "(R command)" Recently that macro started blowing up, returning #RErrors, and when I try to trace the error I find that it is

Hi list, I used to work with RExcel in excel 2003. Now in 2007, I tried the same RExcel, but it did not work. I got R version 12. I downloaded/installed the latest version of RExcel 3.2.0 from http://sunsite.univie.ac.at/rcom/. It has added the RExcel add-ins, but when I click on starting R in add-ins, I get the following sequentional errors: Errors: SCtools not available SCTools can not be

Hi, R users, I'm wondering how I can aggregate data in R with different functions for different columns. For example: x<-rep(1:5,3) y<-cbind(x,a=1:15,b=21:35) y<-data.frame(y) I want to aggregate "a" and "b" in y by "x". With "a", I want to use function "mean"; with "b", I want to use function "sum". I tried:

Hola tengo q hacer un trabajo, donde me piden q todas las salidas q haga sean en Power Point (graficos, tablas, etc). Para eso habia empezado a leer algo del paquete R2PPT, pero la verdad es q hay cosas q no entiendo de este paquete. Queria saber si alguien estuvo trabajando con el y obtuvo buenos resultados o si han usado otro paquete para hacerlo. Por ultimo una pregunta: desde Sweave se

Full_Name: Isto Aho Version: 2.0.0 OS: Windows XP Submission from: (NULL) (80.186.9.143) Hi, The bug can be reproduced as follows. Install R 2.0.0 and RExcel. Take an excel sheet having 65000 rows and 11 columns, integer values. Give the 'context' command 'put R val' for the large enough selection of rows. (I didn't check, how many are needed, but it seems that 10000 rows

I am having trouble using R routines from the RExcel add-in, that use lapack.dll. As an example if I start the R kernel from within Excel and execute "x<-rbind(c(1,2),c(1,-1)) z<-solve(x)", I get the following error: "Error in solve.default(x): lapack routines could not be loaded. In addition: Warning message: unable to load shared library "C:\Program