Thanks though - didn’t know there was that ecosystem. I will try that list.
> On Mar 1, 2018, at 5:37 PM, David Winsemius wrote:
>
>
>> On Mar 1, 2018, at 2:02 PM, Michael Ashton
>> wrote:
>>
>> Hi -
>>
>> For a while I've used RExcel without problems to run a repeating portfolio
>> optim
No, this is home use. I wasn’t even aware there was a commercial license.
> On Mar 1, 2018, at 5:37 PM, David Winsemius wrote:
>
>
>> On Mar 1, 2018, at 2:02 PM, Michael Ashton
>> wrote:
>>
>> Hi -
>>
>> For a while I've used RExcel without problems to run a repeating portfolio
>> optimiz
> On Mar 1, 2018, at 2:02 PM, Michael Ashton
> 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 comman
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 sta
*Issue:*
Usage of ETS R codes through RExcel macros in VBA
Given below is my command code:
Rinterface.runrcodefromrange Range(Sheet1!B2:D8)
Following are the codes written in the given cell reference:
#!rput
zz
'Sheet1'!$B$2:$B$22
library(forecast)
zz <- ts(zz,freq=365,start=c(20
Free support for RExcel is available by subscribing to the mailing list at
rcom.univie.ac.at
and posting questions to the list.
On Aug 22, 2013, at 7:04 PM, Jeff Newmiller wrote:
> This is not on topic for this mailing list. See the Statconn website for
> support for RExcel.
__
This is not on topic for this mailing list. See the Statconn website for
support for RExcel.
---
Jeff NewmillerThe . . Go Live...
DCN:Basics: ##.#. ##.#. Live Go...
Hello,
I must tell you once again to address your questions to
r-help@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
John Kane
Kingston ON Canada
> -Original Message-
> From: landronim...@gmail.com
> Sent: Sun, 25 Nov 2012 15:02:16 +0100
> To: jrkrid...@inbox.com
> Subject: Re: [R] RExcel, ROOo and LibreOffice inquiry
>
> On Sun, Nov 25, 2012 at 2:38 PM, John Kane wrote:
>
On Sun, Nov 25, 2012 at 2:38 PM, John Kane wrote:
> Can you supply a link for ROOo ? I don't see it anywhere.
>
Oh, sorry. I thought it was obvious:
http://rcom.univie.ac.at/download.html#ROOo
> Also what do you mean" OpenOffice is deprecated"?
>
> Do you mean in terms of using it with ROOo? O
ane
Kingston ON Canada
> -Original Message-
> From: landronim...@gmail.com
> Sent: Sun, 25 Nov 2012 12:52:55 +0100
> To: r-help@r-project.org
> Subject: [R] RExcel, ROOo and LibreOffice inquiry
>
> Dear all
> I'd like to give RExcel a decent spin, mainly to
Dear all
I'd like to give RExcel a decent spin, mainly to take advantage of
Excel's data management facilities and automatic recalculations.
However I cannot use this Windows-only solution on the platform of my
choice, Linux.
Alternatively I've been considering the cross-platform ROOo, the
OpenOff
I am using the worksheet functions of RExcel. I am trying to pass a datatable
to a function in the following call:
=RApply(O14:O18,D6)
Cells O14:O18 contain the definition of the function. This is a function that
takes one argument which is a data.table. Cell D6 has the name of the
data.table
Hi,
I am using RExcel and trying to pass a line of code into R. When I select
the cell and choose "Run Code" from the RExcel menu then it seems to work
fine.
The problem I face is a need to write a macro to do this operation, as I
need to set up a user interface in excel for other users who don't
Don't they have their own support mailing list? You should review
their documentation for specifics.
--
David.
On Aug 10, 2011, at 12:24 PM, Dr. Alireza Zolfaghari wrote:
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 ve
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-
statconnDCOM and RExcel have their own mailing list.
Please subscribe at rcom.univie.ac.at and post you question there.
On Jun 17, 2011, at 7:55 AM, Takatsugu Kobayashi wrote:
> Hi RUsers,
>
> I am currently tying to use RExcel via R installed in my remote server
> (CentOS 5.5).
> Could you plea
Hi RUsers,
I am currently tying to use RExcel via R installed in my remote server
(CentOS 5.5).
Could you please help me set up a R remote server?
All I know about the server is its IPAddress.
Apologies for my fundamental question.
Thank you so much!
Taka
_
;
> John
>
>
>
>
>
>
> From: Jonathan P Daily
>
> Cc: r-help ; r-help-boun...@r-project.org
> Sent: Mon, April 11, 2011 11:39:12 AM
> Subject: Re: [R] RExcel
>
> It is asking the obvious, but did you run the commands from the
Yes, I did, and no error message. And comRegisterRegistry() returns NULL, not
sure if that matters
John
From: Jonathan P Daily
Cc: r-help ; r-help-boun...@r-project.org
Sent: Mon, April 11, 2011 11:39:12 AM
Subject: Re: [R] RExcel
It is asking the obvious
room when its empty? Does the room,
the thing itself have purpose? Or do we, what's the word... imbue it."
- Jubal Early, Firefly
r-help-boun...@r-project.org wrote on 04/11/2011 02:08:02 PM:
> [image removed]
>
> [R] RExcel
>
> array chip
>
> to:
Hi, I am installing Excel using package "RExcelInstaller". When I tried to run
installRExcel()
I got this error message:
You don not have the R package rcom installed.
The (D)COM server installed which will aloow you to use the background server
in
RExcel.
Since rcom is not installed, foregro
ldlife Service
California, USA
http://www.fws.gov/redbluff/rbdd_jsmp.aspx
- Original Message
> From: Jorge Nieves
> 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 t
Use "/" instead of "\" in the path.
---
Jeff Newmiller The . . Go Live...
DCN: Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Contro
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.
>
>
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 F
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 proble
On Fri, Feb 4, 2011 at 5:36 AM, Clayton Coffman
wrote:
> Is there anything out there which replicates the functionality of
> RExcel on a mac? I have Excel for mac, and would just like something
> which makes its easy to put sheets into R as a dataframe etc.
>
See:
http://rwiki.sciviews.org/doku
On Feb 4, 2011, at 4:36 AM, Clayton Coffman wrote:
> Is there anything out there which replicates the functionality of
> RExcel on a mac? I have Excel for mac, and would just like something
> which makes its easy to put sheets into R as a dataframe etc.
On OSX, I believe that the two primary op
Is there anything out there which replicates the functionality of
RExcel on a mac? I have Excel for mac, and would just like something
which makes its easy to put sheets into R as a dataframe etc.
__
R-help@r-project.org mailing list
https://stat.ethz.c
Please subscribe to the rcom mailing list at
rcom.univie.ac.at
RExcel questions are handled on that list.
On 12/20/2010 9:24 PM, jryan.dani...@gmail.com wrote:
> Hey everyone
>
> When I try to 'get active dataframe' from the context menu in excel using
> Rcmdr menus in excel, only the header and
Hey everyone
When I try to 'get active dataframe' from the context menu in excel using Rcmdr
menus in excel, only the header and first row of data gets copied to the excel
spread sheet. No clue why this is happening. I followed the instructions from
'R through Excel' pg 25-26. I'm using excel 2
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
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 t
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
To: r-help
Sent: Mon, November 22, 2010 8:11:39 PM
Subject: [R] Rexcel
Hello I
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\\BackwardSe
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
[[alte
Please post any qeustions regarding RExcel to the rcom-l mailing list.
You can subscribe at rcom.univie.ac.at
On Aug 9, 2010, at 1:42 PM, Andreas Scherer wrote:
> I have a problem with RExcel which I have now installed on top of R 2.11.0.
> The problem had been posted in 2009 on the forum by so
I have a problem with RExcel which I have now installed on top of R 2.11.0.
The problem had been posted in 2009 on the forum by someone else, but no
(useful) response had been uploaded.
The issue is that
whenever I am trying to start R from excel, or by clicking the[
RExcel2007 with
RCommand
I construct a 2 x 2 table in Excel which contains the following:
Date Value
12/31/20081.0
If I transfer this range to Rexcel with a put dataframe operation to a
variable x, then x$Date is displayed as
Date
1 2008-12-30 23:00:00
The datetime value is one
Remote server has to be a Windows machine also.
RExcel uses (D)COM which is Windows-specific
On 2/22/2010 9:14 AM, Philipp Rappold wrote:
> Dear all,
>
> does anyone know if it is possible to connect a Windows RExcel instance
> to a linux R instance?
>
> Within Rexcel, I find the option "Remote
Dear all,
does anyone know if it is possible to connect a Windows RExcel
instance to a linux R instance?
Within Rexcel, I find the option "Remote Server Address", but I
wonder what the installation procedure on my linux (ubuntu) R looks
like (if possible at all)?
Thanks
Philipp
__
Please post this kind of questions to the rcom mailing list.
You can subscribe at rcom.univie.ac.at
__
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
Hello-
I am a Graduate Assistant for an instructor who has written programs for
statistics calculations such as binomial distributions and regressions.
The programs had worked with no problem in Excel 2003. Now we are trying to
use it with Excel 2007, and we are having some trouble.
I have downl
Hi All
Apologies if this is not the correct mailing list for this question.
I have installed RExcel and RCom from CRAN. R is indicating that I need
an additional file/package "statconnDCOM" from rcom.univie.ac.at
I have been trying to access this website over the last 2 days be it
appears to
Hi,
I'm pretty new to R and VERY new to RExcel. I've just finished setting
it up and I'm having some problems. My first Issue is that if I attempt
to use a function like RApply("sum", A1:A4) from within excel it gives
me an error saying "There seems to be no R process connected to the
server"
When I run a macro that uses RExcel, I get a dialog box that says
"Microsoft Excel is waiting for another application to complete an OLE
action."
There is no error in the RExcel commands in the macro, of that I am sure.
The box appears to be related to the inclusion of RunRFile commands.
The m
Dear all,
I have a question regarding background and foreground server in RExcel:
Can somebody explain the main difference between them? As far as I
understood from the RExcel webpage, for both of them one needs rights
for access to Windows registries. The only difference that I can see so
far is
> Hi,
>
> I am trying to run a code in Excel using VBA from R, using
> Rexcel.but everytime I am getting this error.
Error - 2147220502 in module Recel.Rserver
Error running expression
Eval(parse(text="setwd(\"H:\\
> I am using R-2.8.0 and R.2.7
> Please help.
>
>
>
> << OLE Object
Hi,
I have a problem using RExcel with a foreground
server: in RExcel menu as well as in the window called
by "set server" the foreground server option is grayed
out. I have installed the rcom package and also tried
to open R and type require(rcom), as explained on
http://sunsite.univie.ac.at/rcom
50 matches
Mail list logo
