Displaying 20 results from an estimated 3000 matches similar to: "Rexcel question"
2009 Mar 27
0
RExcel rcom Server Loading The Wrong Version of R
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" I can then see an R Console open up and I get a message saying R
2009 Feb 06
0
RExcel waiting for OLE action
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 macro will run through the second RunRFile command, but will not
execute the
2011 May 17
0
Hi! Help using FitARMA package in RExcel
Hi all :)
Before posting, I used the "search" function to find a solution, but I
wasn't lucky.
I'm using RExcel; I've read several examples which explain how to call in
RExcel an R function via =RApply(...) but I don't understand how may I
include in the function several numeric arguments.
Take this example: I want to use the following R function from
2010 Nov 22
4
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]]
2007 Oct 09
0
Using Rexcel: How to work with a range of data?
Hi,
I am trying to use an R function over a column of data I have in my
excel spreadsheet. I do the following:-
1) assign an object (calling it xaxis) to the data by typing in
=Rput("xaxis",a1:a10), where my data is shown in cells
a1:a10
Now I wish to arrive at the mean of these numbers and am doing the
following in another cell:-
=Rapply("mean","xaxis")
This
2008 Apr 17
0
RExcelInstaller
RExcelInstaller_2.0-15
installs RExcel, an add-in for Excel, which connects R and Excel.
RExcel allows to transfer data between R and Excel,
writing VBA macros using R as a library for Excel,
and calling R functions as worksheet function in Excel.
RExcel integrates nicely with R Commander (Rcmdr),
turning R Commander's menus into Excel menus.
It comes with a comprehensive set of example
2008 Mar 20
2
I need help integrating ggplot2 into Excel
Dear all
I use ggplot2 extensively for my plotting routines and rexcel to have the
best of two worlds. (RExcel v 1.75 and R (D)Com v. 2.5)
I can run my ggplot functions, such as qplot(...), in scratchpad mode, but
not in Macro nor Worksheet functions mode.
I have tried the following in Macro mode:
Call RInterface.RRun("library(ggplot2)")
...
Call
2013 Feb 11
1
Putting an array from excel into R Studio
Dear All,
I have been using RExcel for some time and find two features especially useful:
i) The ability to select part of a worksheet and put it into R
ii) The way of viewing the code, the output and the alerts in separate panes.
The rest of R Excel I don't really use.
The major benefit for me is i) as I can use the excel as a sort of
fast access database which is convenient to edit. I can
2009 Oct 07
1
RExcel
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 downloaded RandFriends and have ran the binomial distribution
process in 2007 Excel and have received an
2009 Aug 31
1
RE xcel - two problems - Running RExcel & Working Directory error
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
2013 Sep 01
0
cannot install RExcel
I have followed the instructions according to:
http://rcom.univie.ac.at/download.html#RExcel
-- "You will have to install
. a suitable version of R (I have installed R 3.0.1, CRAN Amsterdam)
. a matching version of rscproxy
. statconnDCOM or rcom with statconnDCOM
Download RExcel 3.2.13
2011 Aug 10
1
RExcel
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
2007 Oct 18
0
Nice reference to R
Just saw this in the Windows Secret blog:
Get official and unofficial fixes for Excel
By Brian Livingston
Despite the hotfix that Microsoft recently released for Excel 2007, as
I described on Oct. 11, some math errors that you should know about
still lurk in both Excel 2007 and Excel 2003.
I'll bring you up to date and explain how you can get better results from Excel.
Baier and
2009 Oct 05
0
Apply R in Excel through RExcel
ryusuke:
It sounds like you need to have (D)COM server to be able to work on the background. As for the foreground, rcom is what you need and it appears to be working OK. I am out of my office right now but I'll back to work next week and I will be able to explain in more detail how the applications I tied together work with RExcel and R. You can download the latest staconnDCOM.latest.exe from
2011 Sep 09
0
RExcel - RunRFile Errors
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 know how
to use R.
In R to run my entire code I simply write on line:
2013 Aug 22
0
Usage of ETS R codes through RExcel macros in VBA
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(2009,1))
etsz <- ets(zz,model='AAN')
etszP <- forecast(etsz,h=34)
write.table(etszP)
How
2018 Mar 01
0
RExcel issues
> 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
2004 Nov 14
1
overflow in RExcel (PR#7368)
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
2012 Oct 27
1
help install RExcel
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
2004 Nov 14
1
excel/r interface
Dear all,
I am quite new to R and for preofessional reasons I was interested in the R/excel interface by Baier and Neuwirth. After setup I see the Rexcel and the Rhelp on the Menu bar of Microsoft Excel XP. However, after putting the formula =RApply("pchisqr", 30, 1) Excel returns the message "could not start Rserver". Any suggestions how to fix this. How do run this